Postgres Pro
Downloads
Home   >   mailing lists

Re: Duplicate Key violation on dump&reload using pg_restore - Mailing list pgsql-general

From Markus Wollny
Subject Re: Duplicate Key violation on dump&reload using pg_restore
Date
Msg-id 28011CD60FB1724DBA4442E38277F62607CD83D7@hermes.computec.de
Whole thread Raw
In response to Duplicate Key violation on dump&reload using pg_restore  ("Markus Wollny" <Markus.Wollny@computec.de>)
List pgsql-general
Tree view
Tom Lane wrote:
> Maybe there actually is a duplicate key in the source DB --- have you
> checked?  There were some bugs in early 8.2.x releases that could
> possibly allow that to happen.

Thanks, I was hoping there would be an easy explanation like that. I guess I'll have to do a little reading up on the change logs of post-8.2.4-releases :)

Computec Media AG

Sitz der Gesellschaft und Registergericht: Fürth (HRB 8818)

Vorstandsmitglieder: Johannes S. Gözalan (Vorsitzender) und Rainer Rosenbusch

Vorsitzender des Aufsichtsrates: Jürg Marquard

Umsatzsteuer-Identifikationsnummer: DE 812 575 276

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Duplicate Key violation on dump&reload using pg_restore
Next
From: Alex Vinogradovs
Date:
Subject: Re: too many LWLocks taken