diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-08-30 22:18:07 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-08-30 22:18:07 +0000 |
| commit | 26993b2918551552b74b559ab410228dc0670cd5 (patch) | |
| tree | fec5ed9634d32bd3720684da549ee2b9ec59916a /doc/src | |
| parent | 549928d99bab650f684fd69dd5ef95553438a957 (diff) | |
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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/release.sgml | 3 | ||||
| -rw-r--r-- | doc/src/sgml/runtime.sgml | 25 |
2 files changed, 26 insertions, 2 deletions
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"> @@ -1136,6 +1136,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</></> <listitem> |