Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_type oid's do they change from version to version - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: pg_type oid's do they change from version to version
Date
Msg-id 40AC0A10.8020102@familyhealth.com.au
Whole thread Raw
In response to Re: pg_type oid's do they change from version to version  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: pg_type oid's do they change from version to version  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: pg_type oid's do they change from version to version  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
> I don't think we have ever changed oids for existing data types, so you
> should be OK.

Are you sure?  If we remove a type, then its oid becomes up for grabs by 
the unused_oids script.

We have removed a few functions in 7.4 (oidsrand, etc.) and I wouldn't 
be surprised if we haven't _already_ reused those oids...

I think the core should mandate it as policy never to reuse oids and 
perhaps make the unused_oids script "remember" what has been used...

Chris

pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: Call for 7.5 feature completion
Next
From: Jan Wieck
Date:
Subject: Re: Table Spaces