1ROLLBACK(7)             PostgreSQL 9.2.24 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, TRANSACTION
17           Optional key words. They have no effect.
18

NOTES

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

EXAMPLES

26       To abort all changes:
27
28           ROLLBACK;
29

COMPATIBILITY

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

SEE ALSO

35       BEGIN(7), COMMIT(7), ROLLBACK TO SAVEPOINT (ROLLBACK_TO_SAVEPOINT(7))
36
37
38
39PostgreSQL 9.2.24                 2017-11-06                       ROLLBACK(7)