Historical version. PostgreSQL 6.5 has reached end of support. See the current manual.
ROLLBACK
Name
ROLLBACK — Aborts the current transactionROLLBACK [ WORK | TRANSACTION ]
Inputs
None.
Outputs
- ABORT
Message returned if successful.
- NOTICE: UserAbortTransactionBlock and not in in-progress state ABORT
If there is not any transaction currently in progress.
Description
ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.
Notes
The keywords WORK and TRANSACTION are noise and can be omitted.
Use COMMIT [source reference unavailable] [source chapter] to successfully terminate a transaction.
Usage
To abort all changes:
ROLLBACK WORK;
Compatibility
SQL92
Full compatibility. The TRANSACTION keyword is a Postgres extension.
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.
Historical source references (1)
Some targets are absent from this original edition. Those references are marked in the text; the original URI remains available here.
sql-commit.htm#SQL-COMMIT-TITLE