Duplicate key violates unique constraint - Mailing list pgsql-bugs

From Umesh Kirdat
Subject Duplicate key violates unique constraint
Date
Msg-id 1387539535.65669.YahooMailNeo@web193105.mail.sg3.yahoo.com
Whole thread Raw
Responses Re: Duplicate key violates unique constraint  (Greg Stark <stark@mit.edu>)
List pgsql-bugs
Hello All,=0A=A0=0AI have been using pg_dump/pg_restore to backup and resto=
re the database in our product for quite sometime.=0AOne of our customers r=
eported an issue with multiple entries for a field marked as primary key.=
=0A=A0=0AAfter investigation of the logs we found the multiple entires were=
 created during pg_restore and the primary key constraint on the field coul=
d not be created due to unique constraint violation.=0A=A0=0AAfter searchin=
g on internet I came across the Postgres BUG 8382 & 3231 & 7760 reported in=
 the past for this issue.=0A=A0=0AThe Postgres version on which the issue w=
as reported is 8.2.2=0AWe have upgraded our Postgres version to 9.0.4 in th=
e current product release and I would like to know whether the issue in dis=
cussion is fixed in Postgres 9.0.4?=0A=A0=0AThank you,=0AUmesh Kirdat

pgsql-bugs by date:

Previous
From: peters@mitre.org
Date:
Subject: BUG #8687: HashAggregate runs out of memory
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #8662: psql -H and ts_headline