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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_type oid's do they change from version to version
Дата
Msg-id 200405200132.i4K1WXp08284@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: pg_type oid's do they change from version to version  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: pg_type oid's do they change from version to version  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Table Spaces
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: pg_type oid's do they change from version to version