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

时间：2025-03-14 09:56:54

云数据库 GAUSSDB

示例

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