RELEASE SAVEPOINT
This page documents the preview version (v2.21). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.
Synopsis
Use the RELEASE SAVEPOINT statement to release the server-side state associated with tracking a savepoint and make the named savepoint no longer accessible to ROLLBACK TO.
Syntax
Grammar
DiagramSemantics
release
RELEASE [ SAVEPOINT ] name
NAME
The name of the savepoint you wish to release.
Other savepoints may be released
When you release a savepoint, all savepoints that were created after it was created are also released.Examples
Begin a transaction and create a savepoint.
BEGIN TRANSACTION;
SAVEPOINT test;
Once you are done with it, release the savepoint:
RELEASE test;
If at this point, you attempt to rollback to test, it will be an error:
ROLLBACK TO test;
ERROR: savepoint "test" does not exist