ABORT(7) - f34

1ABORT(7)                 PostgreSQL 13.3 Documentation                ABORT(7)
2
3
4

NAME

6       ABORT - abort the current transaction
7

SYNOPSIS

9       ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
10

DESCRIPTION

12       ABORT rolls back the current transaction and causes all the updates
13       made by the transaction to be discarded. This command is identical in
14       behavior to the standard SQL command ROLLBACK(7), and is present only
15       for historical reasons.
16

PARAMETERS

18       WORK
19       TRANSACTION
20           Optional key words. They have no effect.
21
22       AND CHAIN
23           If AND CHAIN is specified, a new transaction is immediately started
24           with the same transaction characteristics (see SET TRANSACTION
25           (SET_TRANSACTION(7))) as the just finished one. Otherwise, no new
26           transaction is started.
27

NOTES

29       Use COMMIT(7) to successfully terminate a transaction.
30
31       Issuing ABORT outside of a transaction block emits a warning and
32       otherwise has no effect.
33

EXAMPLES

35       To abort all changes:
36
37           ABORT;
38

COMPATIBILITY

40       This command is a PostgreSQL extension present for historical reasons.
41       ROLLBACK is the equivalent standard SQL command.
42