Open topic with navigation
RELEASE SAVEPOINT — release a previously defined savepoint
Releases a savepoint. See
name of the savepoint.
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