Re: ToDo: pg_backup - using a conditional DROP - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: ToDo: pg_backup - using a conditional DROP
Date
Msg-id 1321454566.30837.1.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: ToDo: pg_backup - using a conditional DROP  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On tis, 2011-11-15 at 22:27 -0500, Tom Lane wrote:
> Now, --clean using DROP IF EXISTS would be targeted at, um, what case?
> I guess the idea is to be able to load into a database that sort of
> mostly shares the same schema as the one you dumped from, only it's
> not the same (if it were the same, you'd not need IF EXISTS). 

What about a schema that is nominally the same, but some object is
missing, because some earlier attempt to clean things up, or because
it's an earlier version of the schema, or because of some batch jobs
make things come and go.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: includeifexists in configuration file
Next
From: Yeb Havinga
Date:
Subject: Re: [PATCH] Unremovable tuple monitoring