Re: extensible enum types

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: extensible enum types
Дата
Msg-id 29292.1277330935@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: extensible enum types  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: extensible enum types  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Well, we don't need the enum value to map into the entire oid range. 
> Can't we just add one to the top-most value and see if there is a
> conflict?

If you don't use the OID counter to generate the new value, you're going
to have problems with race conditions.  There's also that small chance
that there is no free value before 2^32.

The bottom line here is not wanting a feature that "usually" works but
fails once in awhile on the basis of conditions the user can't control.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: extensible enum types
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: extensible enum types