Postgresql transaction

BEGIN;
UPDATE accounts SET balance = balance - 100.00
    WHERE name = 'Alice';
SAVEPOINT my_savepoint;
UPDATE accounts SET balance = balance + 100.00
    WHERE name = 'Bob';
-- oops ... forget that and use Wally's account
ROLLBACK TO my_savepoint;
UPDATE accounts SET balance = balance + 100.00
    WHERE name = 'Wally';
COMMIT;

Source: postgresql.org

Similar codes

1 vote117 views1 answer
Mysql get latest duplicate rows
SQL
0 vote119 views1 answer
Do you know sql
SQL
0 vote112 views1 answer
Sqlite referential integrity
SQL
0 vote126 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
6 votes118 views6 answers
Count mysql
SQL
0 vote130 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
4 votes138 views4 answers
Mysql get date from datetime
SQL
0 vote131 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote114 views1 answer
Default value false mysql
SQL
0 vote125 views1 answer
Dump only data
SQL