ROLLBACK

PostgreSQL
Prev		Next

ROLLBACK

Name

ROLLBACK — Aborts the current transaction

ROLLBACK [ WORK | TRANSACTION ]

None.

ABORT: Message returned if successful.
NOTICE: ROLLBACK: no transaction in progress: If there is not any transaction currently in progress.

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

Use COMMIT to successfully terminate a transaction. ABORT is a synonym for ROLLBACK.

To abort all changes:

ROLLBACK WORK;

SQL92 only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise full compatibility.

Prev	Home	Next
REVOKE	Up	SELECT