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 vote362 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
2 votes343 views1 answer
Docker run postgres locally
SQL
0 vote377 views1 answer
Mysql grant grant option
SQL
0 vote368 views3 answers
Postgresql allow remote connections
SQL
16 votes376 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote393 views1 answer
Query builder doctrien return sql
SQL
0 vote341 views1 answer
On update current_timestamp jpa
SQL
1 vote339 views1 answer
Primary key reset in SQL database
SQL
0 vote410 views1 answer
Mariadb create index if not exists
SQL
0 vote410 views1 answer
How to get button for every record from mysql
SQL