In PostgreSQL, if a DB exception is raised (unique_violation), the whole transaction will abort: there is no way to retry.