RELEASE SAVEPOINT statement to release the server-side state associated with tracking a savepoint and make the named savepoint no longer accessible to
savepoint_release ::= RELEASE [ SAVEPOINT ] name
RELEASE [ SAVEPOINT ] name
The name of the savepoint you wish to release.
Other savepoints may be releasedWhen you release a savepoint, all savepoints that were created after it was created are also released.
Begin a transaction and create a savepoint.
BEGIN TRANSACTION; SAVEPOINT test;
Once you are done with it, release the savepoint:
If at this point, you attempt to rollback to
test, it will be an error:
ROLLBACK TO test;
ERROR: savepoint "test" does not exist