Contents
ABORT
An SQL command for rolling back the current transaction
ABORT
is a transaction command for rolling back the current transaction.
ABORT
has always been present in PostgreSQL.
Usage
ABORT
is functionally equivalent to the SQL standard ROLLBACK
command and has been retained for historical reasons.
Change history
- PostgreSQL 12
[ AND [ NO ] CHAIN ]
syntax added (commit 280a408b)
Examples
Basic execution of ABORT
:
postgres=# BEGIN; BEGIN postgres=*# SELECT 1; ?column? ---------- 1 (1 row) postgres=*# ABORT; ROLLBACK
References
- PostgreSQL documentation: ABORT