Re: pg_restore duplicate key violations

Поиск
Список
Период
Сортировка
От Karl O. Pinc
Тема Re: pg_restore duplicate key violations
Дата
Msg-id 1147188694l.18374l.7l@mofo
обсуждение исходный текст
Ответ на Re: pg_restore duplicate key violations  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore duplicate key violations
Следующее
От: Dan Armbrust
Дата:
Сообщение: Problem dropping a table