"Gauthier, Dave" <dave.gauth...@intel.com> writes: > I have a long list of records I want to insert into a table in such a way as > I can trap and report any/all constraint violations before rolling back (or > opting to commit). > Unfortunately, after I hit the first constraint violation, it aborts the > transaction, and then reports “ERROR: current transaction is aborted, > commands ignored until end of > transaction block”. > > Is there a way around this?
Either load to another table with no constraint then use it as a source for loading the constrained one, excluding the problematic rows: INSERT INTO ... SELECT * FROM import.table LEFT JOIN ... ; Or try using pgloader once the input format is CSV like rather than INSERT. Regards, -- dim -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
