1ABORT(7)                PostgreSQL 9.2.24 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, TRANSACTION
19           Optional key words. They have no effect.
20

NOTES

22       Use COMMIT(7) to successfully terminate a transaction.
23
24       Issuing ABORT when not inside a transaction does no harm, but it will
25       provoke a warning message.
26

EXAMPLES

28       To abort all changes:
29
30           ABORT;
31

COMPATIBILITY

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

SEE ALSO

37       BEGIN(7), COMMIT(7), ROLLBACK(7)
38
39
40
41PostgreSQL 9.2.24                 2017-11-06                          ABORT(7)