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 vote345 views1 answer
Spring postgresql reset auto increment to 0
SQL
0 vote344 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote328 views1 answer
Postgres select except
SQL
0 vote316 views1 answer
Linux upload database to mysql
SQL
-1 vote331 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote332 views2 answers
Sqlite
SQL
24 votes323 views5 answers
Sql reset auto increment
SQL
0 vote379 views1 answer
T-sql delete view if exists
SQL
0 vote353 views1 answer
Create schema sql server
SQL
0 vote334 views1 answer
Sql query to select records entered in last 24 hours
SQL