Bulk INSERT with individual failure - Mailing list pgsql-general

From Robert James
Subject Bulk INSERT with individual failure
Date
Msg-id CAGYyBgj79HfTp5HnA2zDusN8AEWocMNMbuOjW3BP8n0=QpdwmQ@mail.gmail.com
Whole thread Raw
Responses Re: Bulk INSERT with individual failure  (Darren Duncan <darren@darrenduncan.net>)
List pgsql-general
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's okay to silently drop bad data in
this case - I don't even need to know about it.

Is there any way to do this, or am I forced to but each record into
its own INSERT?


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Linux Distribution Preferences?
Next
From: Robert James
Date:
Subject: INSERT... WHERE