Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id E1BCF475E88
	for <pgsql-patches@postgresql.org>;
	Sat, 31 Aug 2002 19:27:41 -0400 (EDT)
Received: from joeconway.com (unknown [63.210.180.150])
	by postgresql.org (Postfix) with ESMTP id 23073475E85
	for <pgsql-patches@postgresql.org>;
	Sat, 31 Aug 2002 19:27:41 -0400 (EDT)
Received: from [192.168.5.3] (account jconway HELO joeconway.com)
	by joeconway.com (CommuniGate Pro SMTP 3.5.9)
	with ESMTP-TLS id 1317839 for pgsql-patches@postgresql.org;
	Sat, 31 Aug 2002 16:12:44 -0700
Message-ID: <3D715089.1050507@joeconway.com>
Date: Sat, 31 Aug 2002 16:26:01 -0700
From: Joe Conway <mail@joeconway.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.1) Gecko/20020826
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: PostgreSQL Patches <pgsql-patches@postgresql.org>
Subject: pg_settings doc patch
Content-Type: multipart/mixed; boundary="------------000107020502040602030209"
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/660
X-Sequence-Number: 5196

This is a multi-part message in MIME format.
--------------000107020502040602030209
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Here is a documentation patch for the pg_settings virtual table. If 
there are no objections, please apply.

Thanks,

Joe

--------------000107020502040602030209
Content-Type: text/html;
 name="pg_settings-doc.1.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="pg_settings-doc.1.patch"

Index: doc/src/sgml/catalogs.sgml
===================================================================
RCS file: /opt/src/cvs/pgsql-server/doc/src/sgml/catalogs.sgml,v
retrieving revision 2.56
diff -c -r2.56 catalogs.sgml
*** doc/src/sgml/catalogs.sgml	30 Aug 2002 19:23:18 -0000	2.56
--- doc/src/sgml/catalogs.sgml	31 Aug 2002 22:46:02 -0000
***************
*** 162,167 ****
--- 162,172 ----
       </row>
  
       <row>
+       <entry>pg_settings</entry>
+       <entry>current session run-time parameters</entry>
+      </row>
+ 
+      <row>
        <entry>pg_statistic</entry>
        <entry>optimizer statistics</entry>
       </row>
***************
*** 2858,2863 ****
--- 2863,2924 ----
        <entry><type>text[]</type></entry>
        <entry></entry>
        <entry>Session defaults for run-time configuration variables</entry>
+      </row>
+     </tbody>
+    </tgroup>
+   </table>
+ 
+  </sect1>
+ 
+ 
+  <sect1 id="catalog-pg-settings">
+   <title>pg_settings</title>
+ 
+   <para>
+    <structname>pg_settings</structname> virtual table allows display and update
+    of current session run-time parameters. There is one entry for each of the 
+    available parameters provided by <command>SHOW ALL</command>. But it is
+    in a form that allows it to be joined with other relations and have a
+    selection criteria applied.
+   </para>
+ 
+   <para>
+    An <command>UPDATE</command> performed on <structname>pg_settings</structname>
+    is equivalent to executing the <command>SET</command> command on that named
+    parameter. The change only affects the value used by the current session. If
+    an <command>UPDATE</command> is issued within a transaction that is later
+    aborted, the effects of the <command>UPDATE</command> command disappear when
+    the transaction is rolled back. Once the surrounding transaction is
+    committed, the effects will persist until the end of the session, unless
+    overridden by another <command>UPDATE</command> or <command>SET</command>.
+   </para>
+ 
+   <table>
+    <title>pg_settings Columns</title>
+ 
+    <tgroup cols=4>
+     <thead>
+      <row>
+       <entry>Name</entry>
+       <entry>Type</entry>
+       <entry>References</entry>
+       <entry>Description</entry>
+      </row>
+     </thead>
+ 
+     <tbody>
+      <row>
+       <entry>name</entry>
+       <entry><type>text</type></entry>
+       <entry></entry>
+       <entry>The name of a current session run-time parameter</entry>
+      </row>
+ 
+      <row>
+       <entry>setting</entry>
+       <entry><type>text</type></entry>
+       <entry></entry>
+       <entry>The value of a current session run-time parameter</entry>
       </row>
      </tbody>
     </tgroup>

--------------000107020502040602030209--