• Go to alphabetical list of all man pages

Linux Man Page Viewer

The following form allows you to view linux man pages.

Command:

savepoint

SYNOPSIS

       SAVEPOINT savepoint_name

DESCRIPTION

       SAVEPOINT establishes a new savepoint within the current transaction.

       A savepoint is a special mark inside a transaction that allows all com-
       mands that are executed after it was established  to  be  rolled  back,
       restoring the transaction state to what it was at the time of the save-
       point.

PARAMETERS

       savepoint_name
              The name to give to the new savepoint.

NOTES

       Use ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)] to rollback  to  a
       savepoint.  Use  RELEASE  SAVEPOINT [release_savepoint(7)] to destroy a
       savepoint, keeping the effects of commands executed after it was estab-
       lished.

       Savepoints  can  only  be  established when inside a transaction block.
       There can be multiple savepoints defined within a transaction.

EXAMPLES

       To establish a savepoint and later undo the  effects  of  all  commands
       executed after it was established:

       BEGIN;
           INSERT INTO table1 VALUES (1);
           SAVEPOINT my_savepoint;
           INSERT INTO table1 VALUES (2);
           ROLLBACK TO SAVEPOINT my_savepoint;
           INSERT INTO table1 VALUES (3);
       COMMIT;

       The above transaction will insert the values 1 and 3, but not 2.

       To establish and later destroy a savepoint:

       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.

COMPATIBILITY

SQL - Language Statements 2014-02-17 SAVEPOINT(7)