PQendcopy:resetting connection Problem and Cannot insert a duplicate key into unique index

From: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: PQendcopy:resetting connection Problem and Cannot insert a duplicate key into unique index
Date: 2010-02-03 09:35:16
Message-ID: FA20D4C4FEBFD148B1C0CB09913825FC01EBD52EE0@XCH-SW-06V.sw.nos.boeing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I managed to restore my database. However, one table is not restored.
The error message that I was received was "copy: line 3057, Cannot insert a duplicate key into unique index users_pkey..." and then "...PQendcopy:resetting connection"

Then I went to the log file (my debug file was set to level 5),
ProcessUtility: COPY "users" FROM stdin;
ERROR: copy: line 3057, Cannot insert a duplicate key into unique index users_pkey"

My question is that line #3057. Do I count it from the line where it did "COPY "users" FROM stdin" as the first line and count up to 3057 lines (that line is the problem)?

Any help is appreciated.
My pgverions is postgresql-7.1.3-2.

Thanks
Mary

------------------------------------------------
Mary Y Wang

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florent THOMAS 2010-02-03 09:35:30 Re: Attribute a value to a record
Previous Message Albe Laurenz 2010-02-03 09:05:56 Re: Attribute a value to a record