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.