Vertica Analytics Platform Version 9.2.x Documentation
Destroys a savepoint without undoing the effects of commands executed after the savepoint was established.
RELEASE [ SAVEPOINT ] savepoint_name
Specifies the name of the savepoint to destroy.
Once destroyed, the savepoint is unavailable as a rollback point.
The following example establishes and then destroys a savepoint called my_savepoint. The values 101 and 102 are both inserted at commit.
=> INSERT INTO product_key VALUES (101); => SAVEPOINT my_savepoint; => INSERT INTO product_key VALUES (102); => RELEASE SAVEPOINT my_savepoint; => COMMIT;
Was this topic helpful?