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.
Whoot! I was just thinking about writing such a tool. Thanks.
Chris
Show quoted text
-----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 testedhttp://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?
Feel free to add to it. It's creation was primarily to get Autodoc to
work with my old 7.2 structures.
- Needs to handle mixed case / quoted element names (UNIQUE keys
especially).
- Deferred foreign key constraints.
I use neither, so I'm not overly worried about either unless I get a
bunch of requests.
Show quoted text
On Thu, 2002-09-05 at 21:37, Christopher Kings-Lynne wrote:
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 testedhttp://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?