in a transaction i try to insert into a table1, followed by insert into table 2 then insert into table 3 and last insert into table 4. However if a unique key violation occurs in the table 1 , the whole trabnsaction aborts. is there no way , where i can ignore this violation, and continue with the remaining insertions.
?