Dbms transaction (psql)

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

0 vote247 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote198 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote296 views1 answer
Sqlite woth cmake
SQL
1 vote188 views1 answer
Select statement to print longest name
SQL
5 votes211 views1 answer
Sql table columns
SQL
1 vote229 views1 answer
Select from describe sql
SQL
0 vote255 views1 answer
Reset a table's identity column and remove test records
SQL
8 votes232 views2 answers
How to fetch data from database without last column
SQL
0 vote196 views1 answer
Run sql script file and changes db name in this file using c#
SQL
15 votes196 views2 answers
Select Options
SQL