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? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
