Unsupported versions: 7.0 / 6.5 / 6.4

Historical version. PostgreSQL 7.0 has reached end of support. See the current manual.

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.

Read the upstream documentation. For corrections, first check the current manual.