Re: pg_type oid's do they change from version to version

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