—
NAME
ROLLBACK - abort the current transaction
SYNOPSIS
bash
ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]DESCRIPTION
ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.
PARAMETERS
WORK TRANSACTION
AND CHAIN
NOTES
Use COMMIT to successfully terminate a transaction.
Issuing ROLLBACK outside of a transaction block emits a warning and otherwise has no effect. ROLLBACK AND CHAIN outside of a transaction block is an error.
EXAMPLES
To abort all changes:
bash
ROLLBACK;COMPATIBILITY
The command ROLLBACK conforms to the SQL standard. The form ROLLBACK TRANSACTION is a PostgreSQL extension.
SEE ALSO
BEGIN(7), COMMIT(7), ROLLBACK TO SAVEPOINT (ROLLBACK_TO_SAVEPOINT(7))