RELEASE SAVEPOINT

Destroy a previously defined savepoint.

Summary

RELEASE [SAVEPOINT] savepoint_name

describe

RELEASE SAVEPOINT destroys a save point previously defined in the current transaction.

Destroying the save point makes it impossible to use as a rollback point, but it has no behavior visible to other users. It does not undo the effect of commands executed after a savepoint is established. (For this purpose, see ROLLBACK TO SAVEPOINT.) Destroying a savepoint when it is no longer needed may cause the system to recycle some resources before the transaction ends.

RELEASE SAVEPOINT will also destroy all save points created after the specified save points are created.

Parameters

savepoint_name

The name of the save point to be destroyed.

Example

Create and then destroy a save point:

BEGIN;
    INSERT INTO table1 VALUES (3);
    SAVEPOINT my_savepoint;
    INSERT INTO table1 VALUES (4);
    RELEASE SAVEPOINT my_savepoint;
COMMIT;

The above transactions will be inserted 3 and 4 at the same time.

compatibility