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?