Postgres Pro
Downloads
Home   >   mailing lists

Re: Duplicate key violation on UPDATE - Mailing list pgsql-general

From Tom Lane
Subject Re: Duplicate key violation on UPDATE
Date
Msg-id 7675.1205385823@sss.pgh.pa.us
Whole thread Raw
In response to Duplicate key violation on UPDATE  ("Blair Bethwaite" <blair.bethwaite@infotech.monash.edu.au>)
List pgsql-general
Tree view 
"Blair Bethwaite" <blair.bethwaite@infotech.monash.edu.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

pgsql-general by date:

Previous
From: "Blair Bethwaite"
Date:
Subject: Duplicate key violation on UPDATE
Next
From: Ow Mun Heng
Date:
Subject: Re: Column Statistics - How to dertermine for whole database