summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/end.sgml
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2003-04-26 23:56:51 +0000
committerPeter Eisentraut <peter_e@gmx.net>2003-04-26 23:56:51 +0000
commit20aae3047fb6a04c7cd042873aefa5cba404cfa9 (patch)
tree9b878d9f49120c8235431d6943164918f8a0c9db /doc/src/sgml/ref/end.sgml
parent3a496c8af0912e990b2ba00ae8673f3bf5358242 (diff)
Editing of more reference pages.
Diffstat (limited to 'doc/src/sgml/ref/end.sgml')
-rw-r--r--doc/src/sgml/ref/end.sgml200
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>