Postgres Pro
Downloads
Home   >   mailing lists

Thread: Ok, I broke down...

Ok, I broke down...

From
Rod Taylor
Date:
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.

Re: Ok, I broke down...

From
"Christopher Kings-Lynne"
Date:
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
>

Re: Ok, I broke down...

From
Rod Taylor
Date:
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.

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 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
> > 
>