ROLLBACK(7) PostgreSQL 18.6 Documentation ROLLBACK(7) NAME ROLLBACK - abort the current transaction SYNOPSIS 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 Optional key words. They have no effect. AND CHAIN If AND CHAIN is specified, a new (not aborted) transaction is immedi- ately started with the same transaction characteristics (see SET TRANS- ACTION (SET_TRANSACTION(7))) as the just finished one. Otherwise, no new transaction is started. NOTES Use COMMIT to successfully terminate a transaction. Issuing ROLLBACK outside of a transaction block emits a warning and other- wise has no effect. ROLLBACK AND CHAIN outside of a transaction block is an error. EXAMPLES To abort all changes: ROLLBACK; COMPATIBILITY The command ROLLBACK conforms to the SQL standard. The form ROLLBACK TRANS- ACTION is a PostgreSQL extension. SEE ALSO BEGIN(7), COMMIT(7), ROLLBACK TO SAVEPOINT (ROLLBACK_TO_SAVEPOINT(7)) PostgreSQL 18.6 2026 ROLLBACK(7)
NAME | SYNOPSIS | DESCRIPTION | PARAMETERS | NOTES | EXAMPLES | COMPATIBILITY | SEE ALSO
Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=ROLLBACK&sektion=7&manpath=FreeBSD+Ports+15.1.quarterly>