Re: Reconstructing FKs in pg_dump - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Reconstructing FKs in pg_dump
Date
Msg-id 200209280504.g8S54B210973@candle.pha.pa.us
Whole thread Raw
In response to Re: Reconstructing FKs in pg_dump  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-hackers
Both are done, and in CVS in /contrib/adddepend.

---------------------------------------------------------------------------

Matthew T. O'Connor wrote:
> From: "Tom Lane" <tgl@sss.pgh.pa.us>
> > However, if we are going to put that kind of knowledge into pg_dump,
> > it would only be a small further step to have it dump these triggers
> > as ALTER TABLE ADD CONSTRAINT commands instead.  Which would be a lot
> > better for forward compatibility than dumping the raw triggers.
> 
> There was some talk of adding Rod Taylor's identifies upgrade script to
> contrib, or mentioning it in the release.  I think that it upgrades Foreign
> key, Unique, and Serial constraints, is that relevant here?  Could it be
> used (or modified) to handle this situation?  Just a thought.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

--  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,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: version mismatch detection doesn't work
Next
From: Neil Conway
Date:
Subject: Re: making use of large TLB pages