Re: Reconstructing FKs in pg_dump

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