"Blair Bethwaite" <blair.bethwaite@xxxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
