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

Re: failure and silence of SQL commands

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: failure and silence of SQL commands
Date: 2011-04-28 17:40:01
Message-ID: 201104281940.01380.leif@solumslekt.org (view raw or flat)
Thread:
Lists: pgsql-novice
On Thursday 28 April 2011 19:21:39 John Payne wrote:
> Thank you both very much for your help; that was the problem.  Stupid of me
> (the answer came to me in the shower this morning as well).  If anyone out
> there in the developer community is listening, may I respectfully suggest
> that PSQL's behavior --- to return nothing when Enter is hit - is
> pathological.  It would be so simple to return a message like "Waiting for
> the end of the statement." and it would save novices like me a lot of very
> unhappy hours.

If you enter a line in psql without a final ; and then hit Enter, you should 
notice that the prompt changes from a => to a ->. There's your "Waiting for 
the end of the statement" message.

Your suggestion is, frankly said, ridiculous.

regards, Leif.

In response to

Responses

pgsql-novice by date

Next:From: Robert PoorDate: 2011-04-28 17:50:59
Subject: Re: failure and silence of SQL commands
Previous:From: John PayneDate: 2011-04-28 17:21:39
Subject: failure and silence of SQL commands

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