diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-10-09 04:59:38 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-10-09 04:59:38 +0000 |
| commit | d015dcbe4eeaebe6084983945ef68a642c38e0e1 (patch) | |
| tree | 842dbc2a34f8d68a6fc47dfb0f6de539a0f401af /doc/src/sgml/ref | |
| parent | eb949720adf5051b5fc1bd36735a2b35e72bad84 (diff) | |
| download | postgresql-d015dcbe4eeaebe6084983945ef68a642c38e0e1.tar.gz postgresql-d015dcbe4eeaebe6084983945ef68a642c38e0e1.zip | |
Have SET not start transaction when autocommit off, with doc updates.
Diffstat (limited to 'doc/src/sgml/ref')
| -rw-r--r-- | doc/src/sgml/ref/reset.sgml | 8 | ||||
| -rw-r--r-- | doc/src/sgml/ref/set.sgml | 8 |
2 files changed, 14 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/reset.sgml b/doc/src/sgml/ref/reset.sgml index 1af55703cd3..a21aa0239fb 100644 --- a/doc/src/sgml/ref/reset.sgml +++ b/doc/src/sgml/ref/reset.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/reset.sgml,v 1.15 2002/09/21 18:32:54 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/reset.sgml,v 1.16 2002/10/09 04:59:38 momjian Exp $ PostgreSQL documentation --> @@ -66,6 +66,12 @@ SET <replaceable class="parameter">variable</replaceable> TO DEFAULT switches, or per-database or per-user default settings. See the <citetitle>Administrator's Guide</citetitle> for details. </para> + + <para> + See the <command>SHOW</> manual page for details on the transaction + behavior of <command>RESET</>. + </para> + </refsect1> <refsect1> diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index bc3688a5652..1c9bd31e1e9 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.65 2002/09/21 18:32:54 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.66 2002/10/09 04:59:38 momjian Exp $ PostgreSQL documentation --> @@ -109,6 +109,12 @@ SET [ SESSION | LOCAL ] TIME ZONE { <replaceable class="PARAMETER">timezone</rep </para> <para> + With <literal>autocommit</> set to <literal>off</>, <command>SET</> + does not start a new transaction block. See the + <literal>autocommit</> section of the documentation for details. + </para> + + <para> Here are additional details about a few of the parameters that can be set: <variablelist> |