Pegasus InfoCorp: Web site design and web software development company

ABORT (l)

Aborts the current transaction

SYNOPSIS

    ABORT [ WORK | TRANSACTION ]
    

    None.

    ABORT

      Message returned if successful.

    NOTICE: UserAbortTransactionBlock and not in in-progress state

      If there is not any transaction currently in progress.

DESCRIPTION

    ABORT rolls back the current transaction and causes all the updates made by the transaction to be discarded. This command is identical in behavior to the SQL92 command ROLLBACK, and is present only for historical reasons.

    Use COMMIT to successfully terminate a transaction.

USAGE

    To abort all changes:

    ABORT WORK;
    

COMPATIBILITY

    This command is a Postgres extension present for historical reasons. ROLLBACK is the SQL92 equivalent command.