Rolls back the current transaction.

Syntax

ROLLBACK [ WORK ]

Description

You can use the ROLLBACK command to roll back the current transaction and discard all the updates made by the transaction.

Parameters

Parameter Description
WORK An optional keyword, which has no effect.

Notes

You can use the COMMIT command to end a transaction.

If you run ROLLBACK at a time point which is not in a transaction, no changes are made.

Notice If an Oracle-style SPL procedure exists on the runtime stack, an error occurs when you run a ROLLBACK command in a PL/pgSQL procedure.

Examples

Roll back all changes:

ROLLBACK;