Outdated This document is no longer maintained. Refer to the latest version.

ROLLBACK

Function

ROLLBACK rolls back the current transaction and backs out all updates in the transaction.

ROLLBACK backs out of all changes that a transaction makes to a database if the transaction fails to be executed due to a fault.

Precautions

If a ROLLBACK statement is executed out of a transaction, no error occurs, but a notice is displayed.

Syntax

ROLLBACK [ WORK | TRANSACTION ];

Parameter Description

WORK | TRANSACTION

Specifies the optional keyword. that more clearly illustrates the syntax.

Example

-- Start a transaction.
postgres=# START TRANSACTION;

-- Back out all changes.
postgres=# ROLLBACK;

Helpful Links

COMMIT | END

Feedback
    openGauss 2026-11-21 21:26:13
    cancel