Re: pg_upgrade (was: 8.2 features status) - Mailing list pgsql-hackers

From Sander Steffann
Subject Re: pg_upgrade (was: 8.2 features status)
Date
Msg-id 001c01c6ba47$3f6de990$64c8a8c0@balefirehome
Whole thread Raw
In response to Re: 8.2 features status  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Hi,

>> [ concerning handling a change in a single datatype's representation ]
>
>> 1. Under old system, munge the system catalog to add code for new inet
>> type with new OID. Probably needs a shared lib (if you could create
>> type input/output function with pl/pgsql it would help here).
>> 2. Execute ALTER COLUMN TYPE USING to switch to the new type.
>> 3. Shutdown old server
>> 4. Complete catalog changes
>> 5. Startup new version
>
> Probably easier and more flexible just to include both versions of the
> datatype in the new release, and tell people they'd better ALTER COLUMN
> TYPE sometime before updating to release N+2.

Sounds very nice to have for me! Add an easy way to see which columns are 
still in the old format, and upgrading will be so much easier.

- Sander




pgsql-hackers by date:

Previous
From: Joshua Reich
Date:
Subject: Re: AOL Research open-research
Next
From: "Pavel Stehule"
Date:
Subject: Re: proposal for 8.3: Simultaneous assignment for PL/pgSQL