Re: Chatter on DROP SOMETHING IF EXISTS

Peter Eisentraut <peter_e@gmx.net> writes:
> Am Montag, 19. Februar 2007 13:12 schrieb Alvaro Herrera:
>> I don't understand -- what problem you got with "NO OPERATION"?  It
>> seemed a sound idea to me.

> It seems nonorthogonal.  What if only some of the tables you mentioned did not 
> exist?  Do you get "SOME OPERATION"?

I'd say you get DROP TABLE as long as at least one table was dropped.

> There are also other cases where commands don't have an effect but we don't 
> explicitly point that out.

The precedent that I'm thinking about is that the command tag for COMMIT
varies depending on what it actually did.

regression=# begin;
BEGIN
regression=# select 1/0;
ERROR:  division by zero
regression=# commit;
ROLLBACK
regression=#
        regards, tom lane