Re: [GENERAL] Bulk INSERT with individual failure

2013-01-13 Thread Darren Duncan
On 2013.01.13 5:58 PM, Robert James wrote: I need to INSERT a large number of records. For performance reasons, I'd rather send them to Postgres in one giant INSERT. However, if there's a problem in one record (eg one row doesn't meet a constraint), I'd still like the others saved. That is, I

[GENERAL] Bulk INSERT with individual failure

2013-01-13 Thread Robert James
I need to INSERT a large number of records. For performance reasons, I'd rather send them to Postgres in one giant INSERT. However, if there's a problem in one record (eg one row doesn't meet a constraint), I'd still like the others saved. That is, I specifically DO NOT want atomic behavior. It