Re: Inserting 'large' amounts of data

From: Kris Jurka <books(at)ejurka(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Inserting 'large' amounts of data
Date: 2009-08-26 23:59:47
Message-ID: 4A95CC73.1030000@ejurka.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

John R Pierce wrote:
>
> speaking of using JDBC COPY FROM STDIN via this CopyManager
> interface... how does that handle constraint violations, like duplicate
> primary key?
>

Just like a regular copy failure via psql or constraint violation. An
Exception is thrown and the transaction is aborted (which you must
rollback).

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Maciek Sakrejda 2009-08-27 00:03:44 Re: Inserting 'large' amounts of data
Previous Message John R Pierce 2009-08-26 23:55:43 Re: Inserting 'large' amounts of data