Thread: Re: [PATCHES] drop database if exists

> here's a patch for "drop database if exists". Barring objections I will 
> apply it in a day or two.

Should we use the IF EXISTS syntax in pg_dump output?  For all DROP 
commands in clean mode?

Might make it easier to wrap pg_dump output in a transaction?

Chris

Christopher Kings-Lynne wrote:
> 
> > here's a patch for "drop database if exists". Barring objections I will 
> > apply it in a day or two.
> 
> Should we use the IF EXISTS syntax in pg_dump output?  For all DROP 
> commands in clean mode?

Yes, I was thinking it should be used for pg_dump --clean, which is a
TODO item.  I was also thinking the DROP OWNER could be used for
--clean:
       o Allow pg_dump --clean to drop roles that own objects or have         privileges

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073