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