diff options
Diffstat (limited to 'doc/src/sgml/ref/abort.sgml')
| -rw-r--r-- | doc/src/sgml/ref/abort.sgml | 162 |
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> |
