t
 Title: ABORT
 Author: The PostgreSQL Global Development Group
 Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
 Date: 2021
 Manual: PostgreSQL 11.14 Documentation
 Source: PostgreSQL 11.14
 Language: English

 "ABORT" "7" "2021" "PostgreSQL 11.14" "PostgreSQL 11.14 Documentation"
 -----------------------------------------------------------------
 * Define some portability stuff
 -----------------------------------------------------------------
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 http://bugs.debian.org/507673
 http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 -----------------------------------------------------------------
 * set default formatting
 -----------------------------------------------------------------
 disable hyphenation
 disable justification (adjust text to left margin only)
 -----------------------------------------------------------------
 * MAIN CONTENT STARTS HERE *
 -----------------------------------------------------------------
 "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)