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

Re: cannot remove column + no error msg

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Daniel T(dot) Staal" <DStaal(at)usa(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: cannot remove column + no error msg
Date: 2006-12-11 16:11:47
Message-ID: 12858.1165853507@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Daniel T. Staal" <DStaal(at)usa(dot)net> writes:
> On Mon, December 11, 2006 10:11 am, Bram Kuijper said:
>> Second question is related to that. If I type any bogus (e.g.
>> "sflkjdslkfj") onto the psql commandline, PostgreSQL remains silent.

> More related than you think, probably...

> An SQL statement is terminated by a semicolon, and nothing else.  Until
> the statement is ended, there is no error.  I bet if you type bogus
> characters into psql and finish with a ; it will give you an error.

Also, backslash commands take a different path --- it's possible to
execute \d for example while psql still thinks it's accumulating a
multi-line SQL command to send when it finally sees a semicolon.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Bradley RussellDate: 2006-12-11 16:26:49
Subject: delete cascade question
Previous:From: Daniel T. StaalDate: 2006-12-11 15:55:20
Subject: Re: cannot remove column + no error msg

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