Re: Adding an ignore list to pg_restore - Mailing list pgsql-hackers

From Martin Pitt
Subject Re: Adding an ignore list to pg_restore
Date
Msg-id 20060218190038.GB7729@piware.de
Whole thread Raw
In response to Re: Adding an ignore list to pg_restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Adding an ignore list to pg_restore
List pgsql-hackers
Hi Tom!

Tom Lane [2006-02-18 13:32 -0500]:
> Martin Pitt <mpitt@debian.org> writes:
> > The core problem is that we want to not restore objects (mainly
> > tables) in the destination database which already exist.
>
> Why is this a problem?  It's already the default behavior --- the
> creation commands fail but pg_restore keeps going.

The problem is that pg_restore would restore the TABLE DATA object,
although we don't want that (the postgis specific tables are
pre-populated by PostGIS itself, and should not be altered by the
upgrade.

(Stephen knows the details of PostGIS).

Thanks,

Martin
--
Martin Pitt        http://www.piware.de
Ubuntu Developer   http://www.ubuntu.com
Debian Developer   http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Pgfoundry and gborg: shut one down
Next
From: Stephan Szabo
Date:
Subject: Re: [SQL] Interval subtracting