Re: Chatter on DROP SOMETHING IF EXISTS

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Andrew Dunstan <andrew@dunslane.net>, pgsql-hackers@postgresql.org
Date: 2007-02-08T18:54:13Z
Lists: pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> I'm honestly looking for some practical use of this.  We have debated 
> other NOTICE messages over the years, but they at least tell you 
> something you can use after the command.

The objection I had to the original patch (which didn't return a notice)
was that this seemed actively misleading:

	foo=> DROP TABLE IF EXISTS not_there;
	DROP TABLE
	foo=>

I would be satisfied if the returned command tag were something else,
maybe "NO OPERATION".

			regards, tom lane