/
start-transaction.rst
52 lines (31 loc) · 1.05 KB
/
start-transaction.rst
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
.. highlight:: psql
.. _sql-start-transaction:
=====================
``START TRANSACTION``
=====================
CrateDB accepts the ``START TRANSACTION`` statement for compatibility with the
:ref:`PostgreSQL wire protocol <interface-postgresql>`. However, CrateDB does
not support transactions and will silently ignore this statement.
.. SEEALSO::
:ref:`Appendix: SQL compatibility <appendix-compatibility>`
.. rubric:: Table of contents
.. contents::
:local:
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.