START TRANSACTION

CrateDB accepts the START TRANSACTION statement for compatibility with the PostgreSQL wire protocol. However, CrateDB does not support transactions and will silently ignore this statement. .. SEEALSO:

:ref:`Appendix: SQL compatibility <appendix-compatibility>`

Table of contents

Synopsis

START 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

CrateDB will silently ignore the START TRANSACTION statement.

Note

For backwards compatibility reasons, the commas between successive transaction_modes can be omitted.

Parameters

transaction_mode:

This parameter has no effect.