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.
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.
START TRANSACTION command is the same as the
You can end a transaction by using the
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.
START TRANSACTION READ ONLY;