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. 


Reply via email to