Re: pg_upgrade: What is changed?

Zdenek Kotala wrote:
> Martijn van Oosterhout wrote:
> >On Wed, Aug 23, 2006 at 10:26:19AM +0200, Zdenek Kotala wrote:
> >
> ><snip>
> >
> >>1) BKI - catalog.
> >> c) Some records are changed
> >> action: ???
> >
> >They just need to be changed. In principle the datalog needs to be
> >updated so it looks like a database initdb'd with the new version.
>
> Yes I agree but The question is if some OID collision should appears for
> example collision between user function created in the 8.1 and build-in
> function in 8.2.
>
> ! insert OID = 1838 ( numeric_variance 11 10 12 f f t f i 1 1700 "1231"
> _null_ _null_ _null_ numeric_variance - _null_ )

Those OIDs cannot be used for user types, because the OID counter skips
then when wrapping around. See GetNewObjectId.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.