diff options
Diffstat (limited to 'doc/src/sgml/ref/commit.sgml')
-rw-r--r-- | doc/src/sgml/ref/commit.sgml | 23 |
1 files changed, 19 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml index b2e8d5d1807..e4169cd2c62 100644 --- a/doc/src/sgml/ref/commit.sgml +++ b/doc/src/sgml/ref/commit.sgml @@ -21,7 +21,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> -COMMIT [ WORK | TRANSACTION ] +COMMIT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] </synopsis> </refsynopsisdiv> @@ -38,6 +38,10 @@ COMMIT [ WORK | TRANSACTION ] <refsect1> <title>Parameters</title> + <indexterm zone="sql-commit-chain"> + <primary>chained transactions</primary> + </indexterm> + <variablelist> <varlistentry> <term><literal>WORK</literal></term> @@ -48,6 +52,18 @@ COMMIT [ WORK | TRANSACTION ] </para> </listitem> </varlistentry> + + <varlistentry id="sql-commit-chain"> + <term><literal>AND CHAIN</literal></term> + <listitem> + <para> + If <literal>AND CHAIN</literal> is specified, a new transaction is + immediately started with the same transaction characteristics (see <xref + linkend="sql-set-transaction"/>) as the just finished one. Otherwise, + no new transaction is started. + </para> + </listitem> + </varlistentry> </variablelist> </refsect1> @@ -79,9 +95,8 @@ COMMIT; <title>Compatibility</title> <para> - The SQL standard only specifies the two forms - <literal>COMMIT</literal> and <literal>COMMIT - WORK</literal>. Otherwise, this command is fully conforming. + The command <command>COMMIT</command> conforms to the SQL standard. The + form <literal>COMMIT TRANSACTION</literal> is a PostgreSQL extension. </para> </refsect1> |