Absolutely right, the entire transaction is rolled back. But it's worth noting that any violation of a constraint would have the same effect, such as a duplicate value into a column with a unique constraint/index, or violating a check constraint. This...