diff options
Diffstat (limited to 'doc/src/sgml/ref/end.sgml')
| -rw-r--r-- | doc/src/sgml/ref/end.sgml | 200 |
1 files changed, 77 insertions, 123 deletions
diff --git a/doc/src/sgml/ref/end.sgml b/doc/src/sgml/ref/end.sgml index 3852f742863..b672319479e 100644 --- a/doc/src/sgml/ref/end.sgml +++ b/doc/src/sgml/ref/end.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/end.sgml,v 1.8 2002/04/21 19:02:39 thomas Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/end.sgml,v 1.9 2003/04/26 23:56:51 petere Exp $ PostgreSQL documentation --> @@ -8,145 +8,99 @@ PostgreSQL documentation <refentrytitle id="SQL-END-TITLE">END</refentrytitle> <refmiscinfo>SQL - Language Statements</refmiscinfo> </refmeta> + <refnamediv> - <refname> - END - </refname> - <refpurpose> - commit the current transaction - </refpurpose> - </refnamediv> - + <refname>END</refname> + <refpurpose>commit the current transaction</refpurpose> + </refnamediv> + <refsynopsisdiv> - <refsynopsisdivinfo> - <date>1999-07-20</date> - </refsynopsisdivinfo> - <synopsis> +<synopsis> END [ WORK | TRANSACTION ] - </synopsis> - - <refsect2 id="R2-SQL-END-1"> - <refsect2info> - <date>1998-09-08</date> - </refsect2info> - <title> - Inputs - </title> - <para> - - <variablelist> - <varlistentry> - <term>WORK</term> - <term>TRANSACTION</term> - <listitem> - <para> - Optional keywords. They have no effect. - </para> - </listitem> - </varlistentry> - </variablelist> - </para> - </refsect2> - - <refsect2 id="R2-SQL-END-2"> - <refsect2info> - <date>1998-09-08</date> - </refsect2info> - <title> - Outputs - </title> - <para> - - <variablelist> - <varlistentry> - <term><computeroutput> -COMMIT - </computeroutput></term> - <listitem> - <para> - Message returned if the transaction is successfully committed. - </para> - </listitem> - </varlistentry> - <varlistentry> - <term><computeroutput> -WARNING: COMMIT: no transaction in progress - </computeroutput></term> - <listitem> - <para> - If there is no transaction in progress. - </para> - </listitem> - </varlistentry> - </variablelist> - </para> - </refsect2> +</synopsis> </refsynopsisdiv> - <refsect1 id="R1-SQL-END-1"> - <refsect1info> - <date>1998-09-08</date> - </refsect1info> - <title> - Description - </title> + <refsect1> + <title>Description</title> <para> - <command>END</command> is a <productname>PostgreSQL</productname> - extension, and is a synonym for the SQL92-compatible - <xref linkend="sql-commit" endterm="sql-commit-title">. + <command>END</command> commits the current transaction. All changes + made by the transaction become visible to others and are guaranteed + to be durable if a crash occurs. It is a PostgreSQL extension that + is equivalent to <xref linkend="sql-commit" + endterm="sql-commit-title">. </para> + </refsect1> - <refsect2 id="R2-SQL-END-3"> - <refsect2info> - <date>1998-09-08</date> - </refsect2info> - <title> - Notes - </title> - <para> - The keywords WORK and TRANSACTION are noise and can be omitted. - </para> + <refsect1> + <title>Parameters</title> - <para> - Use <xref linkend="SQL-ROLLBACK" endterm="SQL-ROLLBACK-TITLE"> - to abort a transaction. - </para> - </refsect2> + <variablelist> + <varlistentry> + <term><literal>WORK</literal></term> + <term><literal>TRANSACTION</literal></term> + <listitem> + <para> + Optional key words. They have no effect. + </para> + </listitem> + </varlistentry> + </variablelist> </refsect1> + + <refsect1> + <title>Diagnostics</title> + + <variablelist> + <varlistentry> + <term><computeroutput>COMMIT</computeroutput></term> + <listitem> + <para> + Message returned if the transaction was successfully committed. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><computeroutput>WARNING: COMMIT: no transaction in progress</computeroutput></term> + <listitem> + <para> + Message if there is no transaction in progress. + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Notes</title> - <refsect1 id="R1-SQL-END-2"> - <title> - Usage - </title> <para> - To make all changes permanent: + Use <xref linkend="SQL-ROLLBACK" endterm="SQL-ROLLBACK-TITLE"> to + abort a transaction. + </para> + </refsect1> + + <refsect1> + <title>Examples</title> - <programlisting> -END WORK; - </programlisting> + <para> + To commit the current transaction and make all changes permanent: +<programlisting> +END; +</programlisting> </para> </refsect1> - - <refsect1 id="R1-SQL-END-3"> - <title> - Compatibility - </title> - - <refsect2 id="R2-SQL-END-4"> - <refsect2info> - <date>1998-09-08</date> - </refsect2info> - <title> - SQL92 - </title> - <para> - <command>END</command> is a <productname>PostgreSQL</productname> - extension which provides functionality equivalent to - <xref linkend="sql-commit" endterm="sql-commit-title">. - </para> - </refsect2> + <refsect1> + <title>Compatibility</title> + + <para> + <command>END</command> is a <productname>PostgreSQL</productname> + extension that provides functionality equivalent to <xref + linkend="sql-commit" endterm="sql-commit-title">, which is + specified in the SQL standard. + </para> </refsect1> </refentry> |