Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group