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 help of OIDS. But on a prticular server while deleting the duplicate row i got error "ERROR: simple_heap_delete: tuple already updated by self " If I dump the table using pg_dump and restore it in a temorary table without primary key constarint, then i am able to delete the duplicate row. Kindly help in identifying and solving this problem , and why the rows are getting duplicate automatically Regards, Utsav Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the original intended recipient and have erroneously received this message, you are prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts no responsibilities for loss or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.
