11<!--
2- $Header: /cvsroot/pgsql/doc/src/sgml/ref/abort.sgml,v 1.11 2002 /04/21 19:02:39 thomas Exp $
2+ $Header: /cvsroot/pgsql/doc/src/sgml/ref/abort.sgml,v 1.12 2003 /04/15 13:25:08 petere Exp $
33PostgreSQL documentation
44-->
55
@@ -8,130 +8,82 @@ PostgreSQL documentation
88 <refentrytitle id="sql-abort-title">ABORT</refentrytitle>
99 <refmiscinfo>SQL - Language Statements</refmiscinfo>
1010 </refmeta>
11+
1112 <refnamediv>
12- <refname>
13- ABORT
14- </refname>
15- <refpurpose>
16- abort the current transaction
17- </refpurpose>
13+ <refname>ABORT</refname>
14+ <refpurpose>abort the current transaction</refpurpose>
1815 </refnamediv>
16+
1917 <refsynopsisdiv>
20- <refsynopsisdivinfo>
21- <date>1999-07-20</date>
22- </refsynopsisdivinfo>
23- <synopsis>
18+ <synopsis>
2419ABORT [ WORK | TRANSACTION ]
25- </synopsis>
26-
27- <refsect2 id="R2-SQL-ABORT-1">
28- <refsect2info>
29- <date>1998-09-27</date>
30- </refsect2info>
31- <title>
32- Inputs
33- </title>
34-
35- <para>
36- None.
37- </para>
38- </refsect2>
39-
40- <refsect2 id="R2-SQL-ABORT-2">
41- <refsect2info>
42- <date>1998-09-27</date>
43- </refsect2info>
44- <title>
45- Outputs
46- </title>
47-
48- <para>
49-
50- <variablelist>
51- <varlistentry>
52- <term><computeroutput>
53- ROLLBACK
54- </computeroutput></term>
55- <listitem>
56- <para>
57- Message returned if successful.
58- </para>
59- </listitem>
60- </varlistentry>
61- <varlistentry>
62- <term><computeroutput>
63- WARNING: ROLLBACK: no transaction in progress
64- </computeroutput></term>
65- <listitem>
66- <para>
67- If there is not any transaction currently in progress.
68- </para>
69- </listitem>
70- </varlistentry>
71- </variablelist>
72- </para>
73- </refsect2>
20+ </synopsis>
7421 </refsynopsisdiv>
7522
76- <refsect1 id="R1-SQL-ABORT-1">
77- <refsect1info>
78- <date>1998-09-27</date>
79- </refsect1info>
80- <title>
81- Description
82- </title>
23+ <refsect1>
24+ <title>Description</title>
25+
8326 <para>
8427 <command>ABORT</command> rolls back the current transaction and causes
8528 all the updates made by the transaction to be discarded.
8629 This command is identical
87- in behavior to the <acronym>SQL92 </acronym> command <command>ROLLBACK</command>,
30+ in behavior to thestandard <acronym>SQL </acronym> command <command>ROLLBACK</command>,
8831 and is present only for historical reasons.
8932 </para>
90- <refsect2 id="R2-SQL-ABORT-3">
91- <refsect2info>
92- <date>1998-09-27</date>
93- </refsect2info>
94- <title>
95- Notes
96- </title>
97- <para>
98- Use <command>COMMIT</command> to successfully
99- terminate a transaction.
100- </para>
101- </refsect2>
10233 </refsect1>
10334
104- <refsect1 id="R1-SQL-ABORT-2">
105- <title>
106- Usage
107- </title>
35+ <refsect1>
36+ <title>Diagnostics</title>
37+
38+ <variablelist>
39+ <varlistentry>
40+ <term><computeroutput>ROLLBACK</computeroutput></term>
41+ <listitem>
42+ <para>
43+ Message returned if successful.
44+ </para>
45+ </listitem>
46+ </varlistentry>
47+
48+ <varlistentry>
49+ <term><computeroutput>WARNING: ROLLBACK: no transaction in progress</computeroutput></term>
50+ <listitem>
51+ <para>
52+ If there is not any transaction currently in progress.
53+ </para>
54+ </listitem>
55+ </varlistentry>
56+ </variablelist>
57+ </refsect1>
58+
59+ <refsect1>
60+ <title>Notes</title>
61+
62+ <para>
63+ Use <command>COMMIT</command> to successfully
64+ terminate a transaction.
65+ </para>
66+ </refsect1>
67+
68+ <refsect1>
69+ <title>Examples</title>
70+
10871 <para>
10972 To abort all changes:
110- <programlisting>
73+ <programlisting>
11174ABORT WORK;
112- </programlisting>
75+ </programlisting>
11376 </para>
114-
11577 </refsect1>
11678
117- <refsect1 id="R1-SQL-ABORT-3">
118- <title>
119- Compatibility
120- </title>
121-
122- <refsect2 id="R2-SQL-ABORT-4">
123- <refsect2info>
124- <date>1998-09-27</date>
125- </refsect2info>
126- <title>
127- SQL92
128- </title>
129- <para>
130- This command is a <productname>PostgreSQL</productname> extension present
131- for historical reasons. <command>ROLLBACK</command> is the <acronym>SQL92</acronym>
132- equivalent command.
133- </para>
134- </refsect2>
79+ <refsect1>
80+ <title>Compatibility</title>
81+
82+ <para>
83+ This command is a <productname>PostgreSQL</productname> extension
84+ present for historical reasons. <command>ROLLBACK</command> is the
85+ equivalent standard SQL command.
86+ </para>
13587 </refsect1>
13688
13789</refentry>