Postgres Pro
Downloads
Home   >   mailing lists

Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2 - Mailing list pgsql-general

From Bèrto ëd Sèra
Subject Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2
Date
Msg-id CAKwGa_91_PJUUFcvfdfCOHSkh6YPDL4jfnbdOHhqmWZUSFRpXA@mail.gmail.com
Whole thread Raw
In response to Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2  (Nigel Heron <nigel@psycode.com>)
Responses Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2  (Culley Harrelson <harrelson@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2
Next
From: Adrian Klaver
Date:
Subject: Re: How to get the time zone offset