ABORT - abort the current transaction
Contents
Compatibility
This command is a PostgreSQL extension present for historical reasons. ROLLBACK is the equivalent
standard SQL command.
Description
ABORT rolls back the current transaction and causes all the updates made by the transaction to be
discarded. This command is identical in behavior to the standard SQL command ROLLBACK, and is present
only for historical reasons.
Examples
To abort all changes:
ABORT;
Name
ABORT - abort the current transaction
Notes
Use COMMIT to successfully terminate a transaction.
Issuing ABORT outside of a transaction block emits a warning and otherwise has no effect.
Parameters
WORK
TRANSACTION
Optional key words. They have no effect.
AND CHAIN
If AND CHAIN is specified, a new transaction is immediately started with the same transaction
characteristics (see SETTRANSACTION) as the just finished one. Otherwise, no new transaction is
started.
See Also
BEGIN(7), COMMIT(7), ROLLBACK(7) PostgreSQL 17.5 2025 ABORT(7)
Synopsis
ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
