Re: Duplicate key violation on UPDATE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: blair(dot)bethwaite(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Duplicate key violation on UPDATE
Date: 2008-03-13 05:23:43
Message-ID: 7675.1205385823@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Blair Bethwaite" <blair(dot)bethwaite(at)infotech(dot)monash(dot)edu(dot)au> writes:
> Why would we be getting a duplicate key violation on the primary key
> of this table when we aren't doing anything in the UPDATE (that I can
> tell) to change it?

Corrupted index, perhaps? Can you REINDEX that table?

There are at least two known bugs in 8.0.8 that could lead to this type
of index corruption. If you can't immediately upgrade to a later major
release, I'd strongly recommend updating to a more current 8.0.x.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ow Mun Heng 2008-03-13 05:39:40 Re: Column Statistics - How to dertermine for whole database
Previous Message Blair Bethwaite 2008-03-13 04:58:51 Duplicate key violation on UPDATE