Historical version. PostgreSQL 6.4 has reached end of support. See the current manual.
ROLLBACK
Name
ROLLBACK — Aborts the current transactionROLLBACK [ WORK ]
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 keyword WORK is noise and can be omitted.
Use the COMMIT statement to successfully terminate a transaction.
Usage
--To abort all changes: -- ROLLBACK WORK;
Compatibility
SQL92
Full compatibility.
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.