ABORT(l)                                                 ABORT(l)

NAME
       ABORT - Aborts the current transaction

SYNOPSIS
       ABORT [ WORK | TRANSACTION ]

   INPUTS
       None.

   OUTPUTS
       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.

   NOTES
       Use COMMIT to successfully terminate a transaction.

USAGE
       To abort all changes:

       ABORT WORK;

COMPATIBILITY
   SQL92
       This command is a Postgres extension present for  histori-
       cal reasons. ROLLBACK is the SQL92 equivalent command.

SQL - Language Statements 15 August 1999                        1