Whoot! I was just thinking about writing such a tool. Thanks.
Chris
> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]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
>
