Name
ROLLBACK -- Aborts the current transaction block and abandons any modifications it would have made.
Synopsis
ROLLBACK [ WORK | TRANSACTION ]
Parameters
-
WORK | TRANSACTION
-
A pair of optional noise keywords. They can be ignored, or used to make your SQL more readable.
Results
-
ABORT
-
The message returned when a transaction is aborted successfully.
-
NOTICE: ROLLBACK: no transaction in progress
-
The notice returned if there is not a transaction in progress to rollback.
Description
Use ROLLBACK to abort a transaction in progress and discard all changes either already made or queued to be made on COMMIT.
Example
The following example demonstrates how to rollback an accidental delete performed within a transaction block:
booktown=#
BEGIN WORK;
BEGIN
booktown=#
DELETE FROM shipments;
DELETE 36
booktown=#
ROLLBACK WORK;
ROLLBACK
