Re: cannot remove column + no error msg

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: cannot remove column + no error msg
Дата
Msg-id 12858.1165853507@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: cannot remove column + no error msg  ("Daniel T. Staal" <DStaal@usa.net>)
Список pgsql-novice
"Daniel T. Staal" <DStaal@usa.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

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Daniel T. Staal"
Дата:
Сообщение: Re: cannot remove column + no error msg
Следующее
От: "Bradley Russell"
Дата:
Сообщение: delete cascade question