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

Re: Reconstructing FKs in pg_dump

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Reconstructing FKs in pg_dump
Date: 2002-09-28 05:04:11
Message-ID: 200209280504.g8S54B210973@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Both are done, and in CVS in /contrib/adddepend.

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

Matthew T. O'Connor wrote:
> From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Neil ConwayDate: 2002-09-28 05:30:45
Subject: Re: making use of large TLB pages
Previous:From: Bruce MomjianDate: 2002-09-28 05:03:24
Subject: Re: version mismatch detection doesn't work

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