Postgres Pro
Downloads
Home   >   mailing lists

Re: PQendcopy:resetting connection Problem and Cannot insert a duplicate key into unique index - Mailing list pgsql-general

From Scott Marlowe
Subject Re: PQendcopy:resetting connection Problem and Cannot insert a duplicate key into unique index
Date
Msg-id dcc563d11002031440t33d86ceq33466792672dcd35@mail.gmail.com
Whole thread Raw
In response to Re: PQendcopy:resetting connection Problem and Cannot insert a duplicate key into unique index  ("Wang, Mary Y" <mary.y.wang@boeing.com>)
List pgsql-general
Tree view 
On Wed, Feb 3, 2010 at 3:31 PM, Wang, Mary Y <mary.y.wang@boeing.com> 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
capabilityof telling me what the duplicated key was ? 

I'd recommend going to 8.3.x if possible, or 8.4.2, the latest version.

Not sure how far back it would tell you which value caused the
failure, but more importantly, 8.3 is will run circles around 7.1 and
is much easier to keep happy from a maintenance perspective.

pgsql-general by date:

Previous
From: "Wang, Mary Y"
Date:
Subject: Re: PQendcopy:resetting connection Problem and Cannot insert a duplicate key into unique index
Next
From: Tom Lane
Date:
Subject: Re: PQendcopy:resetting connection Problem and Cannot insert a duplicate key into unique index