Skip to main content

START TRANSACTION

RisingWave supports read-only transactions. You can use the START TRANSACTION READ ONLY command to start a read-only transaction. For more information about transactions in RisingWave, see Transactions.

The START TRANSACTION command starts the read-write transaction mode, which is not supported yet in RisingWave. For compatibility reasons, this command will still succeed but no transaction is actually started. That is why you need to specify the READ ONLY option to start a transaction in read-only mode.

The START TRANSACTION command is the same as the BEGIN command.

You can end a transaction by using the COMMIT command.

Experimental feature

Read-only transactions is currently an experimental feature in RisingWave, and its functionality is subject to change. We cannot guarantee its continued support in future releases, and it may be discontinued without notice. You may use this feature at your own risk.

Syntax

START TRANSACTION;

Example

START TRANSACTION READ ONLY;
-------RESULT
START_TRANSACTION

Help us make this doc better!