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

Thanks Tom.
I still couldn't find that particular line that caused that problem :-(. Counting was very pain.
Is there anyway that I can tell psql just to "ignore" (I mean don't insert it duplicate key into unique index users_pkey) and just keep going without doing the PQendcopy:resetting connection?

I've a dev server that has some portion of the database (I believe the duplicate problem also occurred in that database), and that user_table is querable with data. Would I be able to find any more detailed information of which exact statement caused that problem?

Mary

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Wednesday, February 03, 2010 7:43 AM
To: Wang, Mary Y
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] PQendcopy:resetting connection Problem and Cannot insert a duplicate key into unique index

"Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com> writes:
> 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)?

IIRC, even as far back as 7.1, that should be read as "the 3057'th row of COPY data for this table". So you can count forward 3057 lines from the COPY command in the dump file ... unless you have any embedded newlines in your data, in which case it could get a bit painful to count correctly.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general