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, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
