Postgres Pro
Downloads
Home   >   mailing lists

Re: Best strategy for bulk inserts where some violate unique constraint? - Mailing list psycopg

From Adrian Klaver
Subject Re: Best strategy for bulk inserts where some violate unique constraint?
Date
Msg-id 527A5817.8020805@gmail.com
Whole thread Raw
In response to Re: Best strategy for bulk inserts where some violate unique constraint?  (Denis Papathanasiou <denis.papathanasiou@gmail.com>)
Responses Re: Best strategy for bulk inserts where some violate unique constraint?
List psycopg
Tree view 
On 11/06/2013 06:50 AM, Denis Papathanasiou wrote:
> On Tue, Nov 5, 2013 at 6:31 PM, Daniele Varrazzo

>
>
> I saw Adrian's reply about how this still won't do what I need in terms
> of ignoring the constraint violators and keeping the valid entries; will
> switching autocommit to True first have the desired effect?

No, a particular COPY is treated as a single transaction.


--
Adrian Klaver
adrian.klaver@gmail.com

psycopg by date:

Previous
From: Denis Papathanasiou
Date:
Subject: Re: Best strategy for bulk inserts where some violate unique constraint?
Next
From: Daniele Varrazzo
Date:
Subject: Re: Best strategy for bulk inserts where some violate unique constraint?