Re: Best strategy for bulk inserts where some violate unique constraint?

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Best strategy for bulk inserts where some violate unique constraint?
Дата
Msg-id 527A5817.8020805@gmail.com
обсуждение исходный текст
Ответ на Re: Best strategy for bulk inserts where some violate unique constraint?  (Denis Papathanasiou <denis.papathanasiou@gmail.com>)
Ответы Re: Best strategy for bulk inserts where some violate unique constraint?  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Список psycopg
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Denis Papathanasiou
Дата:
Сообщение: Re: Best strategy for bulk inserts where some violate unique constraint?
Следующее
От: Daniele Varrazzo
Дата:
Сообщение: Re: Best strategy for bulk inserts where some violate unique constraint?