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

From Bruce Momjian
Subject Re: pg_type oid's do they change from version to version
Date
Msg-id 200405200132.i4K1WXp08284@candle.pha.pa.us
Whole thread Raw
In response to Re: pg_type oid's do they change from version to version  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: pg_type oid's do they change from version to version  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne wrote:
> > 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.

True, but have we ever removed types?  I can't think of one.

> 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...

Yes, for functions that is very true.

> 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...

Oh, yea, we could do that.  In fact, we are only use 25% of available
system oids (from unused_oids):
2546 - 9999

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Table Spaces
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: pg_type oid's do they change from version to version