Nested transactions make no sense
Am I wrong? I mean, on a fundamental level. Say you have an outer transaction to do all the things, and two inner transactions A and B. If transaction A throws an error, and B is fine, you either:
- rollback the whole outer transaction, in which case B being fine is irrelevant.
- rollback A, commit B, and commit the whole thing, in which case the outer transaction was irrelevant.
Written on November 21, 2018