Chapter 9: Transaction Control

Table of Contents

Transaction Statements

SET TRANSACTION

Transaction Parameters

COMMIT

COMMIT Options

ROLLBACK

ROLLBACK Options

SAVEPOINT

RELEASE SAVEPOINT

Internal Savepoints

Savepoints and PSQL

REVIEW STATUS

All sections from this point forward to the end of the chapter are awaiting technical and editorial review.

Everything in Firebird happens in transactions. Units of work are isolated between a start point and an end point. Changes to data remain reversible until the moment the client application instructs the server to commit them.