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)
Список
Дерево обсуждения
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
Дата: