Re: ERROR: Cannot insert a duplicate key into unique index - Mailing list pgsql-general

Tom Lane wrote:
> Hmm.  I'm not aware of any 7.4 bug fix that would affect such a thing,
> so I wouldn't want to bet that 7.4 has really solved the issue.
>
> Digging in the 7.3.2-to-7.3.4 change logs, I see one potentially
> relevant change:

The only thing I can think of is the fix for splitting the first btree
page.  We fixed that in 7.4.  I remember it happened mostly on SMP
machines.

--
  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, Pennsylvania 19073