Re: pg_upgrade: What is changed? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pg_upgrade: What is changed?
Date
Msg-id 20060823132541.GF1963@alvh.no-ip.org
Whole thread Raw
In response to Re: pg_upgrade: What is changed?  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
List pgsql-hackers
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.


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Tricky bugs in concurrent index build
Next
From: Böszörményi Zoltán
Date:
Subject: Re: [PATCHES] COPY view