Re: [HACKERS] drop before create in pg_dump - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] drop before create in pg_dump
Date
Msg-id 24649.916443872@sss.pgh.pa.us
Whole thread Raw
In response to drop before create in pg_dump  (Brook Milligan <brook@trillium.NMSU.Edu>)
Responses Re: [HACKERS] drop before create in pg_dump  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] drop before create in pg_dump  (Brook Milligan <brook@trillium.NMSU.Edu>)
List pgsql-hackers
Brook Milligan <brook@trillium.NMSU.Edu> writes:
> pg_dump won't drop stuff before trying to create it; this makes
> dropping a single table (say) and recreating it difficult to automate
> since it is subject to error if all the stuff doesn't get dropped
> properly.  The following patch causes pg_dump to emit DROP ...
> statements prior to emitting CREATE ... statements.

I think that ought to be driven by a switch to pg_dump ...
much of the time, I would *want* pg_dump's script to fail
if there's already an existing item of the given name.

I see your concern, I just don't think it's the only scenario.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Brook Milligan
Date:
Subject: drop before create in pg_dump
Next
From: Vince Vielhaber
Date:
Subject: Time Zones