From 26993b2918551552b74b559ab410228dc0670cd5 Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Fri, 30 Aug 2002 22:18:07 +0000
Subject: AUTOCOMMIT mode is now an available backend GUC variable; setting it
 to false provides more SQL-spec-compliant behavior than we had before. I am
 not sure that setting it false is actually a good idea yet; there is a lot of
 client-side code that will probably be broken by turning autocommit off.  But
 it's a start.

Loosely based on a patch by David Van Wie.
---
 doc/src/sgml/release.sgml |  3 ++-
 doc/src/sgml/runtime.sgml | 25 ++++++++++++++++++++++++-
 2 files changed, 26 insertions(+), 2 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml
index 78606b68e94..3ba21bc1ab7 100644
--- a/doc/src/sgml/release.sgml
+++ b/doc/src/sgml/release.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.155 2002/08/30 00:28:40 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.156 2002/08/30 22:18:05 tgl Exp $
 -->
 
 <appendix id="release">
@@ -24,6 +24,7 @@ CDATA means the content is "SGML-free", so you can write without
 worries about funny characters.
 -->
 <literallayout><![CDATA[
+No-autocommit mode is available (set autocommit to off)
 Substantial improvements in functionality for functions returning sets
 Client libraries older than 6.3 no longer supported (version 0 protocol removed)
 PREPARE statement allows caching query plans for interactive statements
diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml
index d97e368765d..fbbe6274dc0 100644
--- a/doc/src/sgml/runtime.sgml
+++ b/doc/src/sgml/runtime.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.130 2002/08/30 16:50:49 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.131 2002/08/30 22:18:05 tgl Exp $
 -->
 
 <Chapter Id="runtime">
@@ -1135,6 +1135,29 @@ env PGOPTIONS='-c geqo=off' psql
 
    <para>
     <variablelist>
+     <varlistentry>
+      <term><varname>AUTOCOMMIT</varname> (<type>bool</type>)</term>
+      <indexterm><primary>autocommit</></>
+      <listitem>
+       <para>
+        If set to true, <productname>PostgreSQL</productname> will
+	automatically do a <command>COMMIT</> after each successful command
+	that is not inside an explicit transaction block (that is, unless a
+	<command>BEGIN</> with no matching <command>COMMIT</> has been
+	given).
+	If set to false, <productname>PostgreSQL</productname> will commit
+	the effects of commands only on receiving an explicit
+	<command>COMMIT</> command.  This mode can also be thought of as
+	implicitly issuing <command>BEGIN</> whenever a command is received
+	and <productname>PostgreSQL</productname> is not already inside
+	a transaction block.
+	The default is true, for compatibility with historical
+	<productname>PostgreSQL</productname> behavior.  But for maximum
+	compatibility with the SQL specification, set it to false.
+       </para>
+      </listitem>
+     </varlistentry>
+
      <varlistentry>
       <term><varname>AUSTRALIAN_TIMEZONES</varname> (<type>bool</type>)</term>
       <indexterm><primary>Australian time zones</></>
-- 
cgit v1.2.3