Re: Duplicate key violation on UPDATE

"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