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.