control the statements in a transaction in a more granular fashion through the use of save- points. Savepoints allow you to selectively discard parts of the transaction, while committing the rest. After defining Keep in mind that either releasing or rolling back to a savepoint will automatically release all savepoints that were defined after it. All this is happening within the transaction block, so none of it ac- count, only to find later that we should have credited Wally’s account. We could do it using savepoints like this: BEGIN; UPDATE accounts SET balance = balance - 100.00 WHERE name = ’Alice’; SAVEPOINT

to control the statements in a transaction in a more granular fashion through the use of savepoints. Savepoints allow you to selectively discard parts of the transaction, while committing the rest. After Keep in mind that either releasing or rolling back to a savepoint will automatically release all savepoints that were defined after it. All this is happening within the transaction block, so none of it oversimplified, but there’s a lot of control to be had over a transaction block through the use of savepoints. Moreover, ROLLBACK TO is the only way to regain control of a transaction block that was put in

control the statements in a transaction in a more granular fashion through the use of save- points. Savepoints allow you to selectively discard parts of the transaction, while committing the rest. After defining Keep in mind that either releasing or rolling back to a savepoint will automatically release all savepoints that were defined after it. All this is happening within the transaction block, so none of it ac- count, only to find later that we should have credited Wally’s account. We could do it using savepoints like this: BEGIN; UPDATE accounts SET balance = balance - 100.00 WHERE name = ’Alice’; SAVEPOINT

control the statements in a transaction in a more granular fashion through the use of save- points. Savepoints allow you to selectively discard parts of the transaction, while committing the rest. After defining Keep in mind that either releasing or rolling back to a savepoint will automatically release all savepoints that were defined after it. All this is happening within the transaction block, so none of it ac- count, only to find later that we should have credited Wally’s account. We could do it using savepoints like this: BEGIN; UPDATE accounts SET balance = balance - 100.00 WHERE name = ’Alice’; SAVEPOINT

control the statements in a transaction in a more granular fashion through the use of save- points. Savepoints allow you to selectively discard parts of the transaction, while committing the rest. After defining Keep in mind that either releasing or rolling back to a savepoint will automatically release all savepoints that were defined after it. All this is happening within the transaction block, so none of it ac- count, only to find later that we should have credited Wally’s account. We could do it using savepoints like this: BEGIN; UPDATE accounts SET balance = balance - 100.00 WHERE name = ’Alice’; SAVEPOINT

control the statements in a transaction in a more granular fashion through the use of save- points. Savepoints allow you to selectively discard parts of the transaction, while committing the rest. After defining Keep in mind that either releasing or rolling back to a savepoint will automatically release all savepoints that were defined after it. All this is happening within the transaction block, so none of it ac- count, only to find later that we should have credited Wally’s account. We could do it using savepoints like this: BEGIN; UPDATE accounts SET balance = balance - 100.00 WHERE name = ’Alice’; SAVEPOINT

to control the statements in a transaction in a more granular fashion through the use of savepoints. Savepoints allow you to selectively discard parts of the transaction, while committing the rest. After Keep in mind that either releasing or rolling back to a savepoint will automatically release all savepoints that were defined after it. All this is happening within the transaction block, so none of it oversimplified, but there’s a lot of control to be had over a transaction block through the use of savepoints. Moreover, ROLLBACK TO is the only way to regain control of a transaction block that was put in

control the statements in a transaction in a more granular fashion through the use of save- points. Savepoints allow you to selectively discard parts of the transaction, while committing the rest. After defining Keep in mind that either releasing or rolling back to a savepoint will automatically release all savepoints that were defined after it. All this is happening within the transaction block, so none of it ac- count, only to find later that we should have credited Wally’s account. We could do it using savepoints like this: BEGIN; UPDATE accounts SET balance = balance - 100.00 WHERE name = ’Alice’; SAVEPOINT

to control the statements in a transaction in a more granular fashion through the use of savepoints. Savepoints allow you to selectively discard parts of the transaction, while committing the rest. After Keep in mind that either releasing or rolling back to a savepoint will automatically release all savepoints that were defined after it. All this is happening within the transaction block, so none of it oversimplified, but there’s a lot of control possible in a transaction block through the use of savepoints. Moreover, ROLLBACK TO is the only way to regain control of a transac- tion block that was put

control the statements in a transaction in a more granular fashion through the use of save- points. Savepoints allow you to selectively discard parts of the transaction, while committing the rest. After defining Keep in mind that either releasing or rolling back to a savepoint will automatically release all savepoints that were defined after it. All this is happening within the transaction block, so none of it ac- count, only to find later that we should have credited Wally’s account. We could do it using savepoints like this: BEGIN; UPDATE accounts SET balance = balance - 100.00 WHERE name = ’Alice’; SAVEPOINT