"Wang, Mary Y" writes:
> What would be the newer version of pgsql (I mean a bit higher version of my
> current version) that provides that capability of telling me what the
> duplicated key was ?
Hmm ... [ experiments... ] For the specific case of COPY into a table
with a pre-existing unique i
On Wed, Feb 3, 2010 at 3:31 PM, Wang, Mary Y wrote:
> Thanks Scott and Tom.
> Yes. I know, I know that I need to upgrade :-)
> What would be the newer version of pgsql (I mean a bit higher version of my
> current version) that provides that capability of telling me what the
> duplicated key was
ruary 03, 2010 2:21 PM
To: Scott Marlowe
Cc: Wang, Mary Y; pgsql-general@postgresql.org
Subject: Re: [GENERAL] PQendcopy:resetting connection Problem and Cannot insert
a duplicate key into unique index
Scott Marlowe writes:
> On Wed, Feb 3, 2010 at 2:16 PM, Wang, Mary Y wrote:
>> I
Scott Marlowe writes:
> On Wed, Feb 3, 2010 at 2:16 PM, Wang, Mary Y wrote:
>> 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
On Wed, Feb 3, 2010 at 2:16 PM, Wang, Mary Y wrote:
> 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) an
?
Mary
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Wednesday, February 03, 2010 7:43 AM
To: Wang, Mary Y
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PQendcopy:resetting connection Pro
"Wang, Mary Y" 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 f
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