| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | pg(at)fastcrypt(dot)com, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_type oid's do they change from version to version |
| Date: | 2004-05-20 01:32:33 |
| Message-ID: | 200405200132.i4K1WXp08284@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2004-05-20 01:41:06 | Re: pg_type oid's do they change from version to version |
| Previous Message | Jan Wieck | 2004-05-20 01:32:28 | Re: Table Spaces |