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

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Mark Felegyhazi <m_felegyhazi(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Insert unique fails, still increments ID in a lookup table
Date: 2009-09-21 22:03:58
Message-ID: C6DD546E.C49DD%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christine Penner 2009-09-21 22:13:59 Re: 8.4 installer
Previous Message Scot Kreienkamp 2009-09-21 21:26:34 Re: VMWare file system / database corruption