Whoot! I was just thinking about writing such a tool. Thanks. Chris
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Rod Taylor > Sent: Friday, 6 September 2002 12:38 AM > To: PostgreSQL-development > Subject: [HACKERS] 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. > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
