Unique constraints have nothing to do with transactions. There's no promise that all columns that you run a transaction on will have a unique constraint. Try t

Unique constraints have nothing to do with transactions. There's no promise that all columns that you run a transaction on will have a unique constraint. Try the same thing with no constraint. You should see the transaction fail but not because of a unique constraint. Otherwise there's something incorrect.