In the process of upgrading a few systems for the Beta, I ended up
writing a tool to upgrade the Foreign key, Unique, and Serial objects to
their 7.3 version from the 7.2 version (may work on prior -- but not
guarenteed).
I imagine it'll fail miserably on mixed case, or names with spaces --
but oh well.
Anyway, goes through step by step asking the user if they wish to
upgrade each element. Lightly tested
http://www.rbt.ca/postgresql/upgrade.shtml
It assumes you've already dumped / upgraded / restored to 7.3 before
running the script.
Kinda slow, but safe to run more than once.