SET TRANSACTION

Sets the characteristics of transactions.

Synopsis

1. SET SESSION CHARACTERISTICS AS TRANSACTION transaction_mode [, ...]
2. SET TRANSACTION transaction_mode [, ...]

5. where transaction_mode is one of:

7. ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
8. READ WRITE | READ ONLY
9. [ NOT ] DEFERRABLE

Description

SET SESSION CHARACTERISTICS sets the default transaction characteristics for subsequent transactions of a session.

As CrateDB does not support transactions, this command has no effect and will be ignored. The support was added for compatibility reasons.