summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/reset.sgml
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2002-05-17 01:19:19 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2002-05-17 01:19:19 +0000
commitf0811a74b37427d7ee5eee56b00f7f2ea323d7d6 (patch)
tree51a596c44fd21144383062aa7d2ce852ae270268 /doc/src/sgml/ref/reset.sgml
parentfa613fa1eafd8fd80272a31e8477ad9368c95dbb (diff)
downloadpostgresql-f0811a74b37427d7ee5eee56b00f7f2ea323d7d6.tar.gz
Merge the last few variable.c configuration variables into the generic
GUC support. It's now possible to set datestyle, timezone, and client_encoding from postgresql.conf and per-database or per-user settings. Also, implement rollback of SET commands that occur in a transaction that later fails. Create a SET LOCAL var = value syntax that sets the variable only for the duration of the current transaction. All per previous discussions in pghackers.
Diffstat (limited to 'doc/src/sgml/ref/reset.sgml')
-rw-r--r--doc/src/sgml/ref/reset.sgml13
1 files changed, 10 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/reset.sgml b/doc/src/sgml/ref/reset.sgml
index 69c1f861ee..9f78d9df6c 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.13 2001/12/08 03:24:39 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/reset.sgml,v 1.14 2002/05/17 01:19:16 tgl Exp $
PostgreSQL documentation
-->
@@ -37,7 +37,7 @@ RESET ALL
<term>ALL</term>
<listitem>
<para>
- Resets all run-time parameters to default values.
+ Resets all settable run-time parameters to default values.
</para>
</listitem>
</varlistentry>
@@ -53,11 +53,18 @@ RESET ALL
<command>RESET</command> restores run-time parameters to their
default values. Refer to
<xref linkend="sql-set" endterm="sql-set-title">
- for details. <command>RESET</command> is an alternate form for
+ for details. <command>RESET</command> is an alternate spelling for
<synopsis>
SET <replaceable class="parameter">variable</replaceable> TO DEFAULT
</synopsis>
+
+ The default value is defined as the value that the variable would
+ have had, had no <command>SET</> ever been issued for it in the
+ current session. The actual source of this value might be a
+ compiled-in default, the postmaster's configuration file or command-line
+ switches, or per-database or per-user default settings. See the
+ <citetitle>Administrator's Guide</citetitle> for details.
</para>
</refsect1>