[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

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 bugs in