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

6 votes135 views2 answers
Foreign key sqlite3 python
SQL
1 vote133 views1 answer
Altering the column name in MySQL to have a default value
SQL
2 votes125 views2 answers
Mysql all columns
SQL
0 vote120 views1 answer
How to search query in python3 sqlite3
SQL
2 votes150 views1 answer
Oracle kill session by sql_id
SQL
0 vote118 views1 answer
Add plugins to mysql workbench
SQL
1 vote127 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote130 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote128 views1 answer
Procedure excute monthly oracle
SQL
0 vote138 views1 answer
Select into table variable
SQL