清除前面定的一个保存点
概要
RELEASE[SAVEPOINT]savepoint_name
描述
RELEASE SAVEPOINT销毁先前在当前事务中定义的保存点。
销毁保存点使其不可用作回滚点，但没有其他用户可见的行为。
它不会撤消在保存点建立后执行的命令的影响。 （要这样做，看
滚动保存到SAVEPOINT。）在不再需要时销毁保存点可能会允许系统
在交易结束之前回收一些资源。
RELEASE SAVEPOINT还会销毁在命名的保存点之后建立的所有保存点
成立。
parameter
savepoint_name
The name ofthe savepoint to destroy.
示例
To establish and later destroy asavepoint:
| BEGIN; INSERT INTO table1 VALUES (3); SAVEPOINT my_savepoint; INSERT INTO table1 VALUES (4); RELEASE SAVEPOINT my_savepoint; COMMIT;
The above transaction will insert both 3 and 4.
|
兼容性
This command conforms to the SQLstandard. The standard specifies that the key word savepoint is mandatory, butGreenplum Database allows it to be omitted.
相关参考
BEGIN, SAVEPOINT, ROLLBACK TO SAVEPOINT, COMMIT
636
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
