Re: pg_restore duplicate key violations - Mailing list pgsql-general

From Karl O. Pinc
Subject Re: pg_restore duplicate key violations
Date
Msg-id 1147188694l.18374l.7l@mofo
Whole thread Raw
In response to Re: pg_restore duplicate key violations  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 05/09/2006 10:24:28 AM, Tom Lane wrote:
> "Karl O. Pinc" <kop@meme.com> writes:
> > On 05/08/2006 06:42:18 PM, Tom Lane wrote:
> >> Um ... it looks to me like you're trying to restore into an
> existing
> >> table that already has the same data loaded ...
>
> > I'm not clear on where to start with this.
>
> Well, the first thing is to look at the database after the failure and
> see if there's already data in the table.  I'm betting you'll find
> there
> is.  Then you would start trying to figure out where it came from.

I tried that already.  Nothing in the table.

>
> One thought that comes to mind: maybe the table exists in template1?

Don't think so.  Nothing has gone into template1.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore duplicate key violations
Next
From: Dan Armbrust
Date:
Subject: Problem dropping a table