Duplicate key violates unique constraint
От | Umesh Kirdat |
---|---|
Тема | Duplicate key violates unique constraint |
Дата | |
Msg-id | 1387539535.65669.YahooMailNeo@web193105.mail.sg3.yahoo.com обсуждение исходный текст |
Ответы |
Re: Duplicate key violates unique constraint
|
Список | 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 по дате отправления: