ABORT -- abort the current transaction
ABORT [ WORK | TRANSACTION ]
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
, and is present only for historical reasons.
Optional key words. They have no effect.
to successfully terminate a transaction.
Issuing ABORT when not inside a transaction does no harm, but it will provoke a warning message.
To abort all changes:
This command is a PostgreSQL extension present for historical reasons. ROLLBACK is the equivalent standard SQL command.