PostgreSQL

ROLLBACK — abort the current transaction

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

WORK
#[.term]TRANSACTION# :: Optional key words. They have no effect. [.term]AND CHAIN# :: If AND CHAIN is specified, a new (not aborted) transaction is immediately started with the same transaction characteristics (see [.refentrytitle#SET TRANSACTION]) as the just finished one. Otherwise, no new transaction is started.

Use COMMIT to successfully terminate a transaction.

Issuing ROLLBACK outside of a transaction block emits a warning and otherwise has no effect. ROLLBACK AND CHAIN outside of a transaction block is an error.

To abort all changes:

The command ROLLBACK conforms to the SQL standard. The form ROLLBACK TRANSACTION is a PostgreSQL extension.

[.refentrytitle#BEGIN], COMMIT, ROLLBACK TO SAVEPOINT#

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | Code of Conduct | About PostgreSQL | Contact

Copyright © 1996-2024 The PostgreSQL Global Development Group