2
$PostgreSQL: pgsql/doc/src/sgml/ref/abort.sgml,v 1.16 2003-11-29 19:51:38 pgsql Exp $
3
PostgreSQL documentation
6
<refentry id="SQL-ABORT">
8
<refentrytitle id="sql-abort-title">ABORT</refentrytitle>
9
<refmiscinfo>SQL - Language Statements</refmiscinfo>
13
<refname>ABORT</refname>
14
<refpurpose>abort the current transaction</refpurpose>
17
<indexterm zone="sql-abort">
18
<primary>ABORT</primary>
23
ABORT [ WORK | TRANSACTION ]
28
<title>Description</title>
31
<command>ABORT</command> rolls back the current transaction and causes
32
all the updates made by the transaction to be discarded.
33
This command is identical
34
in behavior to the standard <acronym>SQL</acronym> command
35
<xref linkend="SQL-ROLLBACK" endterm="SQL-ROLLBACK-TITLE">,
36
and is present only for historical reasons.
41
<title>Parameters</title>
45
<term><literal>WORK</literal></term>
46
<term><literal>TRANSACTION</literal></term>
49
Optional key words. They have no effect.
60
Use <xref linkend="SQL-COMMIT" endterm="SQL-COMMIT-TITLE"> to
61
successfully terminate a transaction.
65
Issuing <command>ABORT</> when not inside a transaction does
66
no harm, but it will provoke a warning message.
71
<title>Examples</title>
82
<title>Compatibility</title>
85
This command is a <productname>PostgreSQL</productname> extension
86
present for historical reasons. <command>ROLLBACK</command> is the
87
equivalent standard SQL command.
92
<title>See Also</title>
94
<simplelist type="inline">
95
<member><xref linkend="sql-begin" endterm="sql-begin-title"></member>
96
<member><xref linkend="sql-commit" endterm="sql-commit-title"></member>
97
<member><xref linkend="sql-rollback" endterm="sql-rollback-title"></member>
102
<!-- Keep this comment at the end of the file
107
sgml-minimize-attributes:nil
108
sgml-always-quote-attributes:t
111
sgml-parent-document:nil
112
sgml-default-dtd-file:"../reference.ced"
113
sgml-exposed-tags:nil
114
sgml-local-catalogs:"/usr/lib/sgml/catalog"
115
sgml-local-ecat-files:nil