Re: Chatter on DROP SOMETHING IF EXISTS

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Chatter on DROP SOMETHING IF EXISTS
Дата
Msg-id 11036.1171605674@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Chatter on DROP SOMETHING IF EXISTS  ("Jim C. Nasby" <jim@nasby.net>)
Ответы Re: Chatter on DROP SOMETHING IF EXISTS
Список pgsql-hackers
"Jim C. Nasby" <jim@nasby.net> writes:
> On Thu, Feb 08, 2007 at 01:54:13PM -0500, Tom Lane wrote:
>> I would be satisfied if the returned command tag were something else,
>> maybe "NO OPERATION".

> "TABLE blah DID NOT EXIST" might be less confusing...

You're confusing a command tag with a notice.  In the first place,
we shouldn't assume that applications are ready to deal with
indefinitely long command tags (the backend itself doesn't think they
can be longer than 64 bytes); in the second place, they should be
constant strings for the most part so that simple strcmp()s suffice
to see what happened.  Command tags are meant for programs to deal
with, more than humans.
        regards, tom lane


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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Fixing insecure security definer functions
Следующее
От: Alvaro Herrera
Дата:
Сообщение: buildfarm failure in XML code