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
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
