"Gauthier, Dave" <dave.gauthier@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
violationsbefore rolling back (or opting to commit).
> Unfortunately, after I hit the first constraint violation, it aborts the transaction, and then reports “ERROR:
currenttransaction 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