Name
RELEASE SAVEPOINT — Remove and release save-point from transaction log
Syntax
Common Usage
RELEASE savepoint_name
;
Description
The RELEASE SAVEPOINT
command removes a save-point
from the transaction log. It indicates that any modifications
made since the named save-point was set have been accepted by
the application logic.
Normally, a RELEASE
will not alter the
database or transaction log, other than removing the save-point
marker. Releasing a save-point will not commit any modifications
to disk, nor will it make those changes available to other
database connections accessing the same database. Changes
bounded by a released save-point may still be lost if the
transaction is rolled back to a prior save-point, or if the
whole transaction is rolled back.
The one exception to this rule is if the named save-point was set outside of a transaction, causing an implicit transaction to be started. In that case, releasing the save-point will cause the whole transaction to be committed.
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.