.\" This manpage has been automatically generated by docbook2man 
.\" from a DocBook document.  This tool can be found at:
.\" <http://shell.ipoline.com/~elmert/comp/docbook2X/> 
.\" Please send any bug reports, improvements, comments, patches, 
.\" etc. to Steve Cheng <steve@ggi-project.org>.
.TH "ABORT" "" "02 July 1999" "SQL - Language Statements" ""
.SH NAME
ABORT \- Aborts the current transaction
.SH SYNOPSIS
1998-09-27

.nf
ABORT
.fi
.SS 
"INPUTS"
.PP
None.
.SS 
"OUTPUTS"
.PP
.TP
\fB   ABORT\fR
Message returned if successful.
.TP
\fBNOTICE:  UserAbortTransactionBlock and not in in-progress state ABORT\fR
If there is not any transaction currently in progress.
.SH 
"DESCRIPTION"
.PP
\fBABORT\fR 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 \fBROLLBACK\fR,
and is present only for historical reasons.
.SS 
"NOTES"
.PP
Use the \fBCOMMIT\fR statement to successfully
terminate a transaction.
.SH "USAGE"
.PP

.nf
--To abort all changes
--
ABORT WORK;
.fi
.SH "COMPATIBILITY"
.SS 
"SQL92"
.PP
This command is a Postgres extension present
for historical reasons. \fBROLLBACK\fR is the SQL92
equivalent command.