Horton
Menu

Re: Chatter on DROP SOMETHING IF EXISTS

Pavan Deolasee <pavan.deolasee@gmail.com>

View thread
From: "Pavan Deolasee" <pavan.deolasee@gmail.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Peter Eisentraut" <peter_e@gmx.net>, "Alvaro Herrera" <alvherre@commandprompt.com>, "Bruce Momjian" <bruce@momjian.us>, "Jim C. Nasby" <jim@nasby.net>, "Andrew Dunstan" <andrew@dunslane.net>, pgsql-hackers@postgresql.org
Date: 2007-02-19T15:14:54Z
Lists: pgsql-hackers 
On 2/19/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> 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.
>
>
How about DROP TABLE <cnt> where 'cnt' is the number of tables dropped ?

Thanks,
Pavan

-- 

EnterpriseDB     http://www.enterprisedb.com