Re: Chatter on DROP SOMETHING IF EXISTS - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Chatter on DROP SOMETHING IF EXISTS
Date
Msg-id 11036.1171605674@sss.pgh.pa.us
Whole thread Raw
In response to Re: Chatter on DROP SOMETHING IF EXISTS  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: Chatter on DROP SOMETHING IF EXISTS  (Bruce Momjian <bruce@momjian.us>)
List 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 by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Fixing insecure security definer functions
Next
From: Alvaro Herrera
Date:
Subject: buildfarm failure in XML code