manpagez: man pages & more
man ABORT(7)
Home | html | info | man
ABORT(7)                PostgreSQL 9.4.15 Documentation               ABORT(7)




NAME

       ABORT - abort the current transaction


SYNOPSIS

       ABORT [ WORK | TRANSACTION ]


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 standard SQL command ROLLBACK(7), and is present only
       for historical reasons.


PARAMETERS

       WORK
       TRANSACTION
           Optional key words. They have no effect.


NOTES

       Use COMMIT(7) to successfully terminate a transaction.

       Issuing ABORT outside of a transaction block emits a warning and
       otherwise has no effect.


EXAMPLES

       To abort all changes:

           ABORT;


COMPATIBILITY

       This command is a PostgreSQL extension present for historical reasons.
       ROLLBACK is the equivalent standard SQL command.


SEE ALSO

       BEGIN(7), COMMIT(7), ROLLBACK(7)



PostgreSQL 9.4.15                    2017                             ABORT(7)

PostgreSQL 9.4.15 - Generated Sun Nov 26 18:05:41 CST 2017
© manpagez.com 2000-2025
Individual documents may contain additional copyright information.