Re: [GENERAL] Duplicate key violation on UPDATE

2008-03-12 Thread Tom Lane
"Blair Bethwaite" <[EMAIL PROTECTED]> 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 bu

[GENERAL] Duplicate key violation on UPDATE

2008-03-12 Thread Blair Bethwaite
Hi all, I have recently turned up the postgresql logging facilities on a rather database intensive application in the hope of finding bugs and tuning queries. We're using 8.0.8, though thinking of moving to 8.3 as the new HOT functionality looks like it would be useful for us given the high UPDATE