openGauss SQL参考—SQL语法：START TRANSACTION（2）

示例

--以默认方式启动事务。
openGauss=# START TRANSACTION;
openGauss=# SELECT * FROM tpcds.reason;
openGauss=# END;

--以默认方式启动事务。
openGauss=# BEGIN;
openGauss=# SELECT * FROM tpcds.reason;
openGauss=# END;

--以隔离级别为READ COMMITTED，读/写方式启动事务。
openGauss=# START TRANSACTION ISOLATION LEVEL READ COMMITTED READ WRITE;
openGauss=# SELECT * FROM tpcds.reason;
openGauss=# COMMIT;

--可重复读隔离级别下，带WITH CONSISTENT SNAPSHOT开启事务。
openGauss=# START TRANSACTION WITH CONSISTENT SNAPSHOT;
openGauss=# SELECT * FROM tpcds.reason;
openGauss=# COMMIT;

--非可重复读隔离级别下，带WITH CONSISTENT SNAPSHOT开启事务。
openGauss=# START TRANSACTION WITH CONSISTENT SNAPSHOT;
WARNING:  with constent snapshot only effected in repeatable read mode
openGauss=# SELECT * FROM tpcds.reason;
openGauss=# COMMIT;

相关链接

COMMIT | END，ROLLBACK，SET TRANSACTION