ROLLBACK
abort the current transaction
- Provided by: postgresql-client-16 (Version: 16.15-0ubuntu0.24.04.1)
- Source: postgresql-16
- Report a bug
abort the current transaction
ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.
WORK
TRANSACTION
AND CHAIN
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.
To abort all changes:
ROLLBACK;
The command ROLLBACK conforms to the SQL standard. The form ROLLBACK TRANSACTION is a PostgreSQL extension.
BEGIN(7), COMMIT(7), ROLLBACK TO SAVEPOINT (ROLLBACK_TO_SAVEPOINT(7))