I begin a transaction
In the transaction I have an insert query which violates several constraints.
Since I do not want to rollback the transaction so I can continue I end my insert query with:
ON CONFLICT DO NOTHING
Note: Sice there are several things that could go wrong I did not specify any target
Unfortunately I get the constraint violation error in the console and I have to rollback the transaction.
What am I doing wrong?
I would expect to be able to continue querying in the transaction.
New contributor
Mark Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.