云数据库 GaussDB-ROLLBACK TO SAVEPOINT:示例

时间：2023-11-01 16:22:03

云数据库 GaussDB

示例

--撤销 my_savepoint 建立之后执行的命令的影响。openGauss=# START TRANSACTION;openGauss=# SAVEPOINT my_savepoint;openGauss=# ROLLBACK TO SAVEPOINT my_savepoint;--游标位置不受保存点回滚的影响。openGauss=# DECLARE foo CURSOR FOR SELECT 1 UNION SELECT 2;openGauss=# SAVEPOINT foo;openGauss=# FETCH 1 FROM foo; ?column? ----------        1openGauss=# ROLLBACK TO SAVEPOINT foo;openGauss=# FETCH 1 FROM foo; ?column? ----------        2openGauss=# RELEASE SAVEPOINT my_savepoint;openGauss=# COMMIT;