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