Re: Insert unique fails, still increments ID in a lookup table

Поиск
Список
Период
Сортировка
Искать
От
Scott Ribe
Тема
Re: Insert unique fails, still increments ID in a lookup table
Дата
Msg-id
C6DD546E.C49DD%scott_ribe@killerbytes.com
Ответ на
Список
Дерево обсуждения
Insert unique fails, still increments ID in a lookup table Mark Felegyhazi <m_felegyhazi@yahoo.com>
Re: Insert unique fails, still increments ID in a lookup table Chris <dmagick@gmail.com>
Re: Insert unique fails, still increments ID in a lookup table Scott Ribe <scott_ribe@killerbytes.com>
> Any thoughts?

Yeah, the heat death of the universe will occur before you use up bigint
ids. Of course you could do a quick check for uniqueness first, then only
enter a begin/exception block for atomicity if the value was unique.

-- 
Scott Ribe
scott_ribe@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice


В списке pgsql-general по дате отправления
От: Mark Felegyhazi
Дата:
От: Christine Penner
Дата:
Сообщение: Re: 8.4 installer
FAQ