Postgres Plus Advanced Server Oracle Compatibility Developer's Guide :

Previous PageTable Of ContentsNext Page

3.3.51 ROLLBACK

Name

ROLLBACK -- abort the current transaction

Synopsis

ROLLBACK [ WORK ]

Description

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

Parameters

WORK

Optional key word - has no effect.

Notes

Use COMMIT to successfully terminate a transaction.

Issuing ROLLBACK when not inside a transaction does no harm.

Examples

To abort all changes:

ROLLBACK;

See Also

COMMIT, ROLLBACK TO SAVEPOINT, SAVEPOINT

Previous PageTable Of ContentsNext Page