Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group