Skip site navigation (1) Skip section navigation (2)

Re: Re: pg_dump scripts are no longer ordinary-user friendly

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Philip Warner <pjw(at)rhyme(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: pg_dump scripts are no longer ordinary-user friendly
Date: 2001-03-06 04:04:11
Message-ID: Pine.BSF.4.21.0103051955110.65841-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, 5 Mar 2001, Tom Lane wrote:

> Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> > At 22:26 5/03/01 -0500, Tom Lane wrote:
> >> Now that you mention it, is it a feature at all?  Or a bug?  ISTM poor
> >> form for a data-only restore to assume it may turn off all pre-existing
> >> triggers.
> 
> > Do you recall any of the history - why was it added in the first place?
> 
> No, I don't recall.  It might be worth digging in the archives.

Foreign key constraints with data following the full constraint definition
if the data was in the wrong order.  

Unfortunately it does allow invalid data to be loaded, but for circular
cases I'm not sure how you can do this safely.  I guess for fk, if all the
data loading was in a single transaction and you did something to override
the normal deferrable-ness of the constraint and forced the constraints to
be deferred, it would check at the end of the full load.  This still
breaks for multiple dump files per table and for other random user
triggers that are unsafe on restore though.




In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2001-03-06 04:39:17
Subject: Proposed WAL changes
Previous:From: Philip WarnerDate: 2001-03-06 03:56:24
Subject: Re: Re: pg_dump scripts are no longer ordinary-user friendly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group