1ROLLBACK(7) PostgreSQL 13.4 Documentation ROLLBACK(7)
2
3
4
6 ROLLBACK - abort the current transaction
7
9 ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
10
12 ROLLBACK rolls back the current transaction and causes all the updates
13 made by the transaction to be discarded.
14
16 WORK
17 TRANSACTION
18 Optional key words. They have no effect.
19
20 AND CHAIN
21 If AND CHAIN is specified, a new transaction is immediately started
22 with the same transaction characteristics (see SET TRANSACTION
23 (SET_TRANSACTION(7))) as the just finished one. Otherwise, no new
24 transaction is started.
25
27 Use COMMIT(7) to successfully terminate a transaction.
28
29 Issuing ROLLBACK outside of a transaction block emits a warning and
30 otherwise has no effect. ROLLBACK AND CHAIN outside of a transaction
31 block is an error.
32
34 To abort all changes:
35
36 ROLLBACK;
37
39 The command ROLLBACK conforms to the SQL standard. The form ROLLBACK
40 TRANSACTION is a PostgreSQL extension.
41
43 BEGIN(7), COMMIT(7), ROLLBACK TO SAVEPOINT (ROLLBACK_TO_SAVEPOINT(7))
44
45
46
47PostgreSQL 13.4 2021 ROLLBACK(7)