1ROLLBACK(7)              PostgreSQL 11.6 Documentation             ROLLBACK(7)
2
3
4

NAME

6       ROLLBACK - abort the current transaction
7

SYNOPSIS

9       ROLLBACK [ WORK | TRANSACTION ]
10

DESCRIPTION

12       ROLLBACK rolls back the current transaction and causes all the updates
13       made by the transaction to be discarded.
14

PARAMETERS

16       WORK
17       TRANSACTION
18           Optional key words. They have no effect.
19

NOTES

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

EXAMPLES

27       To abort all changes:
28
29           ROLLBACK;
30

COMPATIBILITY

32       The SQL standard only specifies the two forms ROLLBACK and ROLLBACK
33       WORK. Otherwise, this command is fully conforming.
34

SEE ALSO

36       BEGIN(7), COMMIT(7), ROLLBACK TO SAVEPOINT (ROLLBACK_TO_SAVEPOINT(7))
37
38
39
40PostgreSQL 11.6                      2019                          ROLLBACK(7)