rollback7l
Abort the current transaction
Usage
ROLLBACK [ WORK | TRANSACTION ]
Inputs
None.
Outputs
- ABORT
-
Message returned if successful.
- NOTICE: ROLLBACK: no transaction in progress
-
If there is not any transaction currently in progress.
Overview
ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.
Notes
Use COMMIT [commit(l)] to successfully terminate a transaction. ABORT [abort(l)] is a synonym for ROLLBACK.
Usage
To abort all changes:
ROLLBACK WORK;
Compatibility
SQL92
SQL92 only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise full compatibility.
Releases
6 releases since Debian 1.2 (Rex); the text changed 4 times.