Ok, I broke down...

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.