BEGIN / COMMIT Statements #

[EXPLAIN | PROFILE]
[BEGIN]
statement[; statement ...]
[COMMIT]

Amelie transactions require that all transaction statements must be provided for execution.

If BEGIN is defined, it must be strictly at the beginning of the transaction, followed by the COMMIT statement at the end. Multiple statements are separated using the ; symbol or defined using CTE.

All provided statements are always atomical and transactional, regardless of whether there were BEGIN/COMMIT statements.

begin;
update accounts set ammount = ammount + 5 where client = 1;
update accounts set ammount = ammount - 5 where client = 2;
commit;