Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2

From: Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com>
To: Nigel Heron <nigel(at)psycode(dot)com>
Cc: Culley Harrelson <harrelson(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2
Date: 2011-12-30 16:20:58
Message-ID: CAKwGa_91_PJUUFcvfdfCOHSkh6YPDL4jfnbdOHhqmWZUSFRpXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

> Are you sure there is just one record?

What happens if you grep the backup file for "653009"?

If you do have more than one such record, the quickest way out is to
manually clean it.

Bèrto

--
==============================
If Pac-Man had affected us as kids, we'd all be running around in a
darkened room munching pills and listening to repetitive music.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-12-30 16:36:56 Re: How to get the time zone offset
Previous Message Adrian Klaver 2011-12-30 16:19:53 Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2