Re: Avoid transaction abot if/when constraint violated

"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