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

NAME

6       ABORT - abort the current transaction
7

SYNOPSIS

9       ABORT [ WORK | TRANSACTION ]
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

NOTES

23       Use COMMIT(7) to successfully terminate a transaction.
24
25       Issuing ABORT outside of a transaction block emits a warning and
26       otherwise has no effect.
27

EXAMPLES

29       To abort all changes:
30
31           ABORT;
32

COMPATIBILITY

34       This command is a PostgreSQL extension present for historical reasons.
35       ROLLBACK is the equivalent standard SQL command.
36

SEE ALSO

38       BEGIN(7), COMMIT(7), ROLLBACK(7)
39
40
41
42PostgreSQL 10.7                      2019                             ABORT(7)
Impressum