BEGIN
¶
Start a transaction block
Table of contents
Synopsis¶
BEGIN [ WORK | TRANSACTION ] [ transaction_mode [ , ...] ]
where transaction_mode
is one of:
ISOLATION LEVEL isolation_level | (READ WRITE | READ ONLY) | [NOT] DEFERRABLE
where isolation_level
is one of:
{ SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
Description¶
The statement starts a transaction block.
As CrateDB does not support transactions, the only effect of this command is
to start a scope in which cursors WITHOUT HOLD
can be
declared.
Note
Cursors WITHOUT HOLD
are closed automatically after an
END or COMMIT command. There is no
nesting and this happens regardless of how many times BEGIN has run.
Note
For backwards compatibility reasons, the commas between successive
transaction_modes
can be omitted.
Parameters¶
- WORK | TRANSACTION:
Optional key words. They have no effect.
- transaction_mode:
The transactional mode parameter. It has no effect.