Re: failure and silence of SQL commands - Mailing list pgsql-novice

From Tom Lane
Subject Re: failure and silence of SQL commands
Date
Msg-id 25877.1303997338@sss.pgh.pa.us
Whole thread Raw
In response to failure and silence of SQL commands  ("John Payne" <drjohnpayne@gmail.com>)
Responses Re: failure and silence of SQL commands  (Lew <noone@lewscanon.com>)
List pgsql-novice
"John Payne" <drjohnpayne@gmail.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

pgsql-novice by date:

Previous
From: Francisco Leovey
Date:
Subject: PgAdmin no longer works on a "clean install" XP SP2
Next
From: Lew
Date:
Subject: Re: weird results from trivial SELECT statement