Re: failure and silence of SQL commands

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "John Payne" <drjohnpayne(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: failure and silence of SQL commands
Date: 2011-04-28 13:28:58
Message-ID: 25877.1303997338@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"John Payne" <drjohnpayne(at)gmail(dot)com> writes:
> I'm running psql version 8.1.11 on a Linux server from the command line. It
> gives me absolutely no feedback from SQL commands and all SQL commands fail,
> but the internal psql commands such as /d or /echo all work. I am not
> running it in silent mode; the command I use to start it is just the
> standard "psql -d database -U user". It tells me that I'm connected, I can
> examine the tables, but it won't execute SQL.

It would be easier to tell what was going on if you showed us a concrete
example (ie cut and paste from your terminal window) ... but I'm going
to take a stab in the dark and guess that maybe you're forgetting to
terminate your SQL commands with semicolons?

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Lew 2011-04-28 13:31:28 Re: weird results from trivial SELECT statement
Previous Message Tom Lane 2011-04-28 13:25:33 Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?