Hello ! 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? Thanks in Advance!
