Notes:

You can use the savepoint option in a nested transaction to explicitly open up a new savepoint.