Re: [GENERAL] ERROR: simple_heap_delete: tuple already updated by self

2009-10-12 Thread Tom Lane
"utsav" writes: > I am using postgres 7.3. on RHEL 4.0 7.3.what? If it's not 7.3.21 then an update would probably be worth your time. In particular there were fixes in 7.3.14 and 7.3.20 that could possibly explain this. If it is 7.3.21, then I think an upgrade to a newer major release series

[GENERAL] ERROR: simple_heap_delete: tuple already updated by self

2009-10-12 Thread utsav
Dear All , I am using postgres 7.3. on RHEL 4.0 I have table on which there are duplicate rows even though there is a primary key constraint.I dont know how the rows got duplicate , because in my s/w there is no such possibility. Wel till now i used to delete the row duplicate row with the he