summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/abort.sgml
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src/sgml/ref/abort.sgml')
-rw-r--r--doc/src/sgml/ref/abort.sgml162
1 files changed, 57 insertions, 105 deletions
diff --git a/doc/src/sgml/ref/abort.sgml b/doc/src/sgml/ref/abort.sgml
index 1e5b9bf890..15116144b6 100644
--- a/doc/src/sgml/ref/abort.sgml
+++ b/doc/src/sgml/ref/abort.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/abort.sgml,v 1.11 2002/04/21 19:02:39 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/abort.sgml,v 1.12 2003/04/15 13:25:08 petere Exp $
PostgreSQL documentation
-->
@@ -8,130 +8,82 @@ PostgreSQL documentation
<refentrytitle id="sql-abort-title">ABORT</refentrytitle>
<refmiscinfo>SQL - Language Statements</refmiscinfo>
</refmeta>
+
<refnamediv>
- <refname>
- ABORT
- </refname>
- <refpurpose>
- abort the current transaction
- </refpurpose>
+ <refname>ABORT</refname>
+ <refpurpose>abort the current transaction</refpurpose>
</refnamediv>
+
<refsynopsisdiv>
- <refsynopsisdivinfo>
- <date>1999-07-20</date>
- </refsynopsisdivinfo>
- <synopsis>
+<synopsis>
ABORT [ WORK | TRANSACTION ]
- </synopsis>
-
- <refsect2 id="R2-SQL-ABORT-1">
- <refsect2info>
- <date>1998-09-27</date>
- </refsect2info>
- <title>
- Inputs
- </title>
-
- <para>
- None.
- </para>
- </refsect2>
-
- <refsect2 id="R2-SQL-ABORT-2">
- <refsect2info>
- <date>1998-09-27</date>
- </refsect2info>
- <title>
- Outputs
- </title>
-
- <para>
-
- <variablelist>
- <varlistentry>
- <term><computeroutput>
-ROLLBACK
- </computeroutput></term>
- <listitem>
- <para>
- Message returned if successful.
- </para>
- </listitem>
- </varlistentry>
- <varlistentry>
- <term><computeroutput>
-WARNING: ROLLBACK: no transaction in progress
- </computeroutput></term>
- <listitem>
- <para>
- If there is not any transaction currently in progress.
- </para>
- </listitem>
- </varlistentry>
- </variablelist>
- </para>
- </refsect2>
+</synopsis>
</refsynopsisdiv>
- <refsect1 id="R1-SQL-ABORT-1">
- <refsect1info>
- <date>1998-09-27</date>
- </refsect1info>
- <title>
- Description
- </title>
+ <refsect1>
+ <title>Description</title>
+
<para>
<command>ABORT</command> 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 <acronym>SQL92</acronym> command <command>ROLLBACK</command>,
+ in behavior to the standard <acronym>SQL</acronym> command <command>ROLLBACK</command>,
and is present only for historical reasons.
</para>
- <refsect2 id="R2-SQL-ABORT-3">
- <refsect2info>
- <date>1998-09-27</date>
- </refsect2info>
- <title>
- Notes
- </title>
- <para>
- Use <command>COMMIT</command> to successfully
- terminate a transaction.
- </para>
- </refsect2>
</refsect1>
- <refsect1 id="R1-SQL-ABORT-2">
- <title>
- Usage
- </title>
+ <refsect1>
+ <title>Diagnostics</title>
+
+ <variablelist>
+ <varlistentry>
+ <term><computeroutput>ROLLBACK</computeroutput></term>
+ <listitem>
+ <para>
+ Message returned if successful.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
+ <term><computeroutput>WARNING: ROLLBACK: no transaction in progress</computeroutput></term>
+ <listitem>
+ <para>
+ If there is not any transaction currently in progress.
+ </para>
+ </listitem>
+ </varlistentry>
+ </variablelist>
+ </refsect1>
+
+ <refsect1>
+ <title>Notes</title>
+
+ <para>
+ Use <command>COMMIT</command> to successfully
+ terminate a transaction.
+ </para>
+ </refsect1>
+
+ <refsect1>
+ <title>Examples</title>
+
<para>
To abort all changes:
- <programlisting>
+<programlisting>
ABORT WORK;
- </programlisting>
+</programlisting>
</para>
-
</refsect1>
- <refsect1 id="R1-SQL-ABORT-3">
- <title>
- Compatibility
- </title>
-
- <refsect2 id="R2-SQL-ABORT-4">
- <refsect2info>
- <date>1998-09-27</date>
- </refsect2info>
- <title>
- SQL92
- </title>
- <para>
- This command is a <productname>PostgreSQL</productname> extension present
- for historical reasons. <command>ROLLBACK</command> is the <acronym>SQL92</acronym>
- equivalent command.
- </para>
- </refsect2>
+ <refsect1>
+ <title>Compatibility</title>
+
+ <para>
+ This command is a <productname>PostgreSQL</productname> extension
+ present for historical reasons. <command>ROLLBACK</command> is the
+ equivalent standard SQL command.
+ </para>
</refsect1>
</refentry>