> Remember that Rod Taylor's written a script to fix at least the foreign key > issue above. I think it'd be neat if that script were perfected and did > serials as well and then we could recommend its use...
It does do serials (adds pg_depend entry -- which is just enough), as well as changes unique indexes into unique constraints. As I had a few items I didn't want to upgrade, it asks the user if they want to do each one (-Y to fix 'em all). -- Rod Taylor ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html