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

From Tom Lane
Subject Re: pg_upgrade (was: 8.2 features status)
Date
Msg-id 19464.1154954234@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgrade (was: 8.2 features status)  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: pg_upgrade (was: 8.2 features status)
List pgsql-hackers
Martijn van Oosterhout <kleptog@svana.org> writes:
> [ 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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: proposal for PL packages for 8.3.
Next
From: andrew@dunslane.net
Date:
Subject: Re: proposal for 8.3: Simultaneous assignment for