Documentation → PostgreSQL 7.0

Unsupported versions: 7.0 / 6.5 / 6.4

Historical version. PostgreSQL 7.0 reached end of support in May 2005. See the current manual for supported releases.

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

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