diff options
Diffstat (limited to 'doc/src/sgml/ref/rollback.sgml')
| -rw-r--r-- | doc/src/sgml/ref/rollback.sgml | 275 |
1 files changed, 148 insertions, 127 deletions
diff --git a/doc/src/sgml/ref/rollback.sgml b/doc/src/sgml/ref/rollback.sgml index d0fa6ec3d02..01c095736da 100644 --- a/doc/src/sgml/ref/rollback.sgml +++ b/doc/src/sgml/ref/rollback.sgml @@ -1,133 +1,154 @@ -<REFENTRY ID="SQL-ROLLBACK"> -<REFMETA> -<REFENTRYTITLE> +<refentry id="SQL-ROLLBACK"> + <refmeta> + <refentrytitle id="SQL-ROLLBACK-TITLE"> ROLLBACK -</REFENTRYTITLE> -<REFMISCINFO>SQL - Language Statements</REFMISCINFO> -</REFMETA> -<REFNAMEDIV> -<REFNAME> + </refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + <refnamediv> + <refname> ROLLBACK -</REFNAME> -<REFPURPOSE> -Aborts the current transaction -</REFPURPOSE> - </refnamediv> -<REFSYNOPSISDIV> -<REFSYNOPSISDIVINFO> -<DATE>1998-09-24</DATE> -</REFSYNOPSISDIVINFO> -<SYNOPSIS> -ROLLBACK [ WORK ] -</SYNOPSIS> + </refname> + <refpurpose> + Aborts the current transaction + </refpurpose> + </refnamediv> + <refsynopsisdiv> + <refsynopsisdivinfo> + <date>1998-09-24</date> + </refsynopsisdivinfo> + <synopsis> +ROLLBACK [ WORK | TRANSACTION ] + </synopsis> - <REFSECT2 ID="R2-SQL-ROLLBACK-1"> - <REFSECT2INFO> - <DATE>1998-09-24</DATE> - </REFSECT2INFO> - <TITLE> - Inputs - </TITLE> - <PARA> - None. - </para> - </REFSECT2> + <refsect2 id="R2-SQL-ROLLBACK-1"> + <refsect2info> + <date>1998-09-24</date> + </refsect2info> + <title> + Inputs + </title> + <para> + None. + </para> + </refsect2> - <REFSECT2 ID="R2-SQL-ROLLBACK-2"> - <REFSECT2INFO> - <DATE>1998-09-24</DATE> - </REFSECT2INFO> - <TITLE> - Outputs - </TITLE> - <PARA> - - <VARIABLELIST> - <VARLISTENTRY> - <TERM> - ABORT - </TERM> - <LISTITEM> - <PARA> - Message returned if successful. - </para> - </listitem> - </VARLISTENTRY> - - <VARLISTENTRY> - <TERM> - NOTICE: UserAbortTransactionBlock and not in in-progress state - ABORT - </TERM> - <LISTITEM> - <PARA> - If there is not any transaction currently in progress. - </para> - </listitem> - </VARLISTENTRY> - </VARIABLELIST> - </para> - </REFSECT2> - </REFSYNOPSISDIV> + <refsect2 id="R2-SQL-ROLLBACK-2"> + <refsect2info> + <date>1998-09-24</date> + </refsect2info> + <title> + Outputs + </title> + <para> + + <variablelist> + <varlistentry> + <term> + ABORT + </term> + <listitem> + <para> + Message returned if successful. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term> + NOTICE: UserAbortTransactionBlock and not in in-progress state + ABORT + </term> + <listitem> + <para> + If there is not any transaction currently in progress. + </para> + </listitem> + </varlistentry> + </variablelist> + </para> + </refsect2> + </refsynopsisdiv> - <REFSECT1 ID="R1-SQL-ROLLBACK-1"> - <REFSECT1INFO> - <DATE>1998-09-24</DATE> - </REFSECT1INFO> - <TITLE> - Description - </TITLE> - <PARA> - <command>ROLLBACK</command> rolls back the current transaction and causes - all the updates made by the transaction to be discarded. - </para> - <REFSECT2 ID="R2-SQL-ROLLBACK-3"> - <REFSECT2INFO> - <DATE>1998-09-24</DATE> - </REFSECT2INFO> - <TITLE> - Notes - </TITLE> - <PARA> - The keyword WORK is noise and can be omitted. - </para> - <para> - Use the <command>COMMIT</command> statement to successfully - terminate a transaction. - </para> - </refsect2> - </REFSECT1> + <refsect1 id="R1-SQL-ROLLBACK-1"> + <refsect1info> + <date>1998-09-24</date> + </refsect1info> + <title> + Description + </title> - <REFSECT1 ID="R1-SQL-ROLLBACK-2"> - <TITLE> - Usage - </TITLE> - <PARA> - <ProgramListing> - --To abort all changes: - -- - ROLLBACK WORK; - </ProgramListing> - </para> - </REFSECT1> - - <REFSECT1 ID="R1-SQL-ROLLBACK-3"> - <TITLE> - Compatibility - </TITLE> - <PARA> - </PARA> - - <REFSECT2 ID="R2-SQL-ROLLBACK-4"> - <REFSECT2INFO> - <DATE>1998-09-24</DATE> - </REFSECT2INFO> - <TITLE> - SQL92 - </TITLE> - <PARA> - Full compatibility. - </para> - </refsect2> - </refsect1> -</REFENTRY> + <para> + <command>ROLLBACK</command> rolls back the current transaction and causes + all the updates made by the transaction to be discarded. + </para> + + <refsect2 id="R2-SQL-ROLLBACK-3"> + <refsect2info> + <date>1998-09-24</date> + </refsect2info> + <title> + Notes + </title> + <para> + The keywords WORK and TRANSACTION are noise and can be omitted. + </para> + + <para> + Use <xref linkend="SQL-COMMIT-TITLE" endterm="SQL-COMMIT-TITLE"> + to successfully terminate a transaction. + </para> + </refsect2> + </refsect1> + + <refsect1 id="R1-SQL-ROLLBACK-2"> + <title> + Usage + </title> + <para> + <programlisting> + --To abort all changes: + -- + ROLLBACK WORK; + </programlisting> + </para> + </refsect1> + + <refsect1 id="R1-SQL-ROLLBACK-3"> + <title> + Compatibility + </title> + <para> + </para> + + <refsect2 id="R2-SQL-ROLLBACK-4"> + <refsect2info> + <date>1998-09-24</date> + </refsect2info> + <title> + SQL92 + </title> + <para> + Full compatibility. TRANSACTION is a + <productname>Postgres</productname> extension. + </para> + </refsect2> + </refsect1> +</refentry> + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag:nil +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: +--> |