RELEASE SAVEPOINT

RELEASE SAVEPOINT — release a previously defined savepoint

Syntax

RELEASE SAVEPOINT savepoint_name

Description

Releases a savepoint. See SAVEPOINT.

Parameters

savepoint_name: name of the savepoint.

Example:

Create and release a savepoint.

AUTOCOMMIT off;
CREATE TABLE t1 (f1 INTEGER);
START TRANSACTION;
INSERT INTO t1 VALUES (1);
SAVEPOINT s1;
INSERT INTO t1 VALUES (2);
RELEASE SAVEPOINT s1;
SELECT * FROM t1;
 F1
 ---
  1
  2
COMMIT;

/* Error generated if savepoint does not exit */
RELEASE SAVEPOINT s1;
savepoint "S1" is not defined