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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
