Re: Duplicate Key violation on dump&reload using pg_restore

From: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Duplicate Key violation on dump&reload using pg_restore
Date: 2008-04-04 23:11:50
Message-ID: 28011CD60FB1724DBA4442E38277F62607CD83D7@hermes.computec.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Vinogradovs 2008-04-04 23:27:15 Re: too many LWLocks taken
Previous Message Tom Lane 2008-04-04 23:09:33 Re: Duplicate Key violation on dump&reload using pg_restore