Functions for transaction management
For general information and examples, see section Transaction control.
Observe the following rules when working with transactions:
The requests in a transaction must be sent to a server as a single block. It is not enough to enclose them between begin and commit or rollback. To ensure they are sent as a single block: put them in a function, or put them all on one line, or use a delimiter so that multi-line requests are handled together.
All database operations in a transaction should use the same storage engine.
It is not safe to access tuple sets that are defined with
and also access tuple sets that are defined with
in the same transaction.
Requests which cause changes to the data definition – create, alter, drop, truncate – must not be used.
Below is a list of all functions for transaction management.
|box.begin()||Begin the transaction|
|box.commit()||End the transaction and save all changes|
|box.rollback()||End the transaction and discard all changes|
|box.savepoint()||Get a savepoint descriptor|
|box.rollback_to_savepoint()||Do not end the transaction and discard all changes made after a savepoint|
|box.atomic()||Execute a function, treating it as a transaction|
|box.on_commit()||Define a trigger that will be activated by
|box.on_rollback()||Define a trigger that will be activated by
|box.is_in_txn()||State whether a transaction is in progress|