Add information on SET SESSION CHARACTERISTICS.

Fix references to pg_hba.conf(5) since that is no longer a man page.
Make minor repairs to "Compatibility" subsections.

8 files changed, 178 insertions, 39 deletions

diff --git a/doc/src/sgml/ref/allfiles.sgml b/doc/src/sgml/ref/allfiles.sgml
index 3611943dbe9..1acdae9b24f 100644
--- a/doc/src/sgml/ref/allfiles.sgml
+++ b/doc/src/sgml/ref/allfiles.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.19 2000/06/18 21:24:51 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.20 2000/07/14 15:27:14 thomas Exp $
 Postgres documentation
 Complete list of usable sgml source files in this directory.
 -->
@@ -98,6 +98,7 @@ Complete list of usable sgml source files in this directory.
 <!entity select             system "select.sgml">
 <!entity selectInto         system "select_into.sgml">
 <!entity set                system "set.sgml">
+<!entity setSession         system "set_session.sgml">
 <!entity setConstraints     system "set_constraints.sgml">
 <!entity setTransaction     system "set_transaction.sgml">
 <!entity show               system "show.sgml">
diff --git a/doc/src/sgml/ref/commands.sgml b/doc/src/sgml/ref/commands.sgml
index 9f6ba8e70dd..28a3e12ab7b 100644
--- a/doc/src/sgml/ref/commands.sgml
+++ b/doc/src/sgml/ref/commands.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/commands.sgml,v 1.26 2000/06/18 21:24:51 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/commands.sgml,v 1.27 2000/07/14 15:27:14 thomas Exp $
 Postgres documentation
 -->
 
@@ -73,6 +73,7 @@ Postgres documentation
    &selectInto;
    &set;
    &setConstraints;
+   &setSession;
    &setTransaction;
    &show;
    &truncate;
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index ce113a3efe2..dd23c1f40e0 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.30 2000/06/09 01:43:57 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.31 2000/07/14 15:27:14 thomas Exp $
 Postgres documentation
 -->
 
@@ -1849,7 +1849,7 @@ CREATE TABLE distributors (
   <title>
    Compatibility
   </title>
-  
+
   <refsect2 id="R2-SQL-CREATETABLE-4">
    <title>
     SQL92
diff --git a/doc/src/sgml/ref/create_user.sgml b/doc/src/sgml/ref/create_user.sgml
index ba389aebe76..2fb981b4d55 100644
--- a/doc/src/sgml/ref/create_user.sgml
+++ b/doc/src/sgml/ref/create_user.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_user.sgml,v 1.14 2000/03/27 17:14:42 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_user.sgml,v 1.15 2000/07/14 15:27:14 thomas Exp $
 Postgres documentation
 -->
 
@@ -75,7 +75,8 @@ CREATE USER <replaceable class="PARAMETER">username</replaceable>
         Sets the user's password. If you do not plan to use password
         authentication you can omit this option, otherwise the user
         won't be able to connect to a password-authenticated server.
-        See pg_hba.conf(5) or the administrator's guide for details on
+        See the chapter on client authentication in the
+	<citetitle>Administrator's Guide</citetitle> for details on
         how to set up authentication mechanisms.
        </para>
       </listitem>
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml
index 044cf8fd65b..7f36aae9d78 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.45 2000/06/18 21:24:52 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.46 2000/07/14 15:27:14 thomas Exp $
 Postgres documentation
 -->
 
@@ -392,13 +392,19 @@ SELECT CURRENT_TIMESTAMP AS today;
  <refsect1 id="R1-SQL-SET-3">
   <title>Compatibility</title>
 
-  <para>
-   The second syntax shown above (<literal>SET TIME ZONE</literal>)
-   attempts to mimic <acronym>SQL92</acronym>. However, SQL allows
-   only numeric time zone offsets. All other parameter settings as
-   well as the first syntax shown above are a
-   <productname>Postgres</productname> extension.
-  </para>
+  <refsect2 id="R2-SQL-SET-4">
+   <title>
+    SQL92
+   </title>
+
+   <para>
+    The second syntax shown above (<literal>SET TIME ZONE</literal>)
+    attempts to mimic <acronym>SQL92</acronym>. However, SQL allows
+    only numeric time zone offsets. All other parameter settings as
+    well as the first syntax shown above are a
+    <productname>Postgres</productname> extension.
+   </para>
+  </refsect2>
  </refsect1>
 </refentry>
 
diff --git a/doc/src/sgml/ref/set_constraints.sgml b/doc/src/sgml/ref/set_constraints.sgml
index 3cdb5d67a21..af8bfcb60ec 100644
--- a/doc/src/sgml/ref/set_constraints.sgml
+++ b/doc/src/sgml/ref/set_constraints.sgml
@@ -1,4 +1,4 @@
-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_constraints.sgml,v 1.1 2000/06/18 21:24:54 petere Exp $ -->
+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_constraints.sgml,v 1.2 2000/07/14 15:27:14 thomas Exp $ -->
 <refentry id="SQL-SET-CONSTRAINTS">
  <refmeta>
   <refentrytitle id="SQL-SET-CONSTRAINTS-title">SET CONSTRAINTS</refentrytitle>
@@ -44,10 +44,33 @@ SET CONSTRAINTS { ALL | <replaceable class="parameter">constraint</replaceable>
   </para>
  </refsect1>
 
- <refsect1>
+ <refsect1 id="R1-SQL-SET-CONSTRAINT-3">
   <title>Compatibility</title>
-  <para>
-   SQL92, SQL99
-  </para>
+
+  <refsect2 id="R2-SQL-SET-CONSTRAINT-4">
+   <title>SQL92, SQL99</title>
+
+   <para>
+    <command>SET CONSTRAINT</command> is defined in
+    <acronym>SQL92</acronym> and <acronym>SQL99</acronym>.
+   </para>
+  </refsect2>
  </refsect1>
 </refentry>
+
+<!-- Keep this comment at the end of the file
+Local variables:
+mode:sgml
+sgml-omittag:nil
+sgml-shorttag:t
+sgml-minimize-attributes:nil
+sgml-always-quote-attributes:t
+sgml-indent-step:1
+sgml-indent-data:t
+sgml-parent-document:nil
+sgml-default-dtd-file:"../reference.ced"
+sgml-exposed-tags:nil
+sgml-local-catalogs:("/usr/lib/sgml/catalog")
+sgml-local-ecat-files:nil
+End:
+-->
diff --git a/doc/src/sgml/ref/set_session.sgml b/doc/src/sgml/ref/set_session.sgml
new file mode 100644
index 00000000000..b542d6646e8
--- /dev/null
+++ b/doc/src/sgml/ref/set_session.sgml
@@ -0,0 +1,91 @@
+<!--
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/set_session.sgml,v 1.1 2000/07/14 15:27:14 thomas Exp $
+Postgres documentation
+-->
+
+<refentry id="SQL-SET-SESSION">
+ <refmeta>
+  <refentrytitle id="SQL-SET-SESSION-TITLE">SET</refentrytitle>
+  <refmiscinfo>SQL - Language Statements</refmiscinfo>
+ </refmeta>
+ <refnamediv>
+  <refname>SET SESSION CHARACTERISTICS</refname>
+  <refpurpose>Set per-session run-time parameters</refpurpose>
+ </refnamediv>
+ <refsynopsisdiv>
+  <synopsis>
+SET SESSION CHARACTERISTICS TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }
+SET SESSION CHARACTERISTICS TIME ZONE { '<replaceable class="PARAMETER">timezone</replaceable>' | LOCAL | DEFAULT }
+  </synopsis>
+ </refsynopsisdiv>
+
+ <refsect1 id="R1-SQL-SET-SESSION-1">
+  <title>Description</title>
+  <para>
+   <command>SET SESSION CHARACTERISTICS</command> changes the run-time
+   environment for the entire <acronym>SQL</acronym>
+   session. Currently, transaction isolation level and time zone can
+   be specified by this command.
+  </para>
+
+  <para>
+   Use <xref linkend="SQL-SHOW" endterm="SQL-SHOW-title"> to show the
+   current setting of a parameters.
+  </para>
+
+  <para>
+   Refer to <xref linkend="SQL-SET-TRANSACTION" endterm="SQL-SET-TRANSACTION-TITLE">
+   and to <xref linkend="SQL-SET" endterm="SQL-SET-TITLE"> for more
+   information on allowed parameters.
+  </para>
+ </refsect1>
+
+ <refsect1>
+  <title>Examples</title>
+
+  <para>
+   Set the timezone for Berkeley, California, using double quotes to
+   preserve the uppercase attributes of the time zone specifier (note
+   that the date/time format is ISO here):
+
+<screen> 
+SET SESSION CHARACTERISTICS TIME ZONE "PST8PDT";
+SELECT CURRENT_TIMESTAMP AS today;
+   
+         today
+------------------------
+ 1998-07-14 07:41:21-07
+</screen>
+  </para>
+ </refsect1>
+
+ <refsect1 id="R1-SQL-SET-SESSION-3">
+  <title>Compatibility</title>
+
+  <refsect2 id="R2-SQL-SET-SESSION-4">
+   <title>SQL99</title>
+
+   <para>
+    <command>SET SESSION</command> is defined in
+    <acronym>SQL99</acronym>.
+   </para>
+  </refsect2>
+ </refsect1>
+</refentry>
+
+<!-- Keep this comment at the end of the file
+Local variables:
+mode:sgml
+sgml-omittag:nil
+sgml-shorttag:t
+sgml-minimize-attributes:nil
+sgml-always-quote-attributes:t
+sgml-indent-step:1
+sgml-indent-data:t
+sgml-parent-document:nil
+sgml-default-dtd-file:"../reference.ced"
+sgml-exposed-tags:nil
+sgml-local-catalogs:("/usr/lib/sgml/catalog")
+sgml-local-ecat-files:nil
+End:
+-->
diff --git a/doc/src/sgml/ref/set_transaction.sgml b/doc/src/sgml/ref/set_transaction.sgml
index e5de2e7f5b4..a5ca5fac1ff 100644
--- a/doc/src/sgml/ref/set_transaction.sgml
+++ b/doc/src/sgml/ref/set_transaction.sgml
@@ -1,7 +1,7 @@
-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_transaction.sgml,v 1.1 2000/06/18 21:24:54 petere Exp $ -->
+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_transaction.sgml,v 1.2 2000/07/14 15:27:14 thomas Exp $ -->
 <refentry id="SQL-SET-TRANSACTION">
  <refmeta>
-  <refentrytitle id="SQL-SET-TRANSACTION-title">SET TRANSACTION</refentrytitle>
+  <refentrytitle id="SQL-SET-TRANSACTION-TITLE">SET TRANSACTION</refentrytitle>
   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  </refmeta>
  <refnamediv>
@@ -66,28 +66,44 @@ SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }
   </para>
  </refsect1>
 
- <refsect1>
+ <refsect1 id="R1-SQL-SET-TRANSACTION-3">
   <title>Compatibility</title>
 
-  <para>
-   SQL92, SQL99
-  </para>
+  <refsect2 id="R2-SQL-SET-TRANSACTION-4">
+   <title>SQL92, SQL99</title>
 
-  <para>
-   SERIALIZABLE is the default level in <acronym>SQL</acronym>.
-   Postgres does not provide the isolation levels <option>READ
-   UNCOMMITTED</option> and <option>REPEATABLE READ</option>. Because
-   of multi-version concurrency control, the serializable level is not
-   truly serializable. See the <citetitle>User's Guide</citetitle> for
-   details.
-  </para>
+   <para>
+    SERIALIZABLE is the default level in <acronym>SQL</acronym>.
+    Postgres does not provide the isolation levels <option>READ
+     UNCOMMITTED</option> and <option>REPEATABLE READ</option>. Because
+    of multi-version concurrency control, the serializable level is not
+    truly serializable. See the <citetitle>User's Guide</citetitle> for
+    details.
+   </para>
 
-  <para>
-   In <acronym>SQL</acronym> there are two other transaction
-   characteristics that can be set with this command: whether the
-   transaction is read-only and the size of the diagnostics area.
-   Neither of these concepts are supported in Postgres.
-  </para>
+   <para>
+    In <acronym>SQL</acronym> there are two other transaction
+    characteristics that can be set with this command: whether the
+    transaction is read-only and the size of the diagnostics area.
+    Neither of these concepts are supported in Postgres.
+   </para>
+  </refsect2>
  </refsect1>
 </refentry>
 
+<!-- Keep this comment at the end of the file
+Local variables:
+mode:sgml
+sgml-omittag:nil
+sgml-shorttag:t
+sgml-minimize-attributes:nil
+sgml-always-quote-attributes:t
+sgml-indent-step:1
+sgml-indent-data:t
+sgml-parent-document:nil
+sgml-default-dtd-file:"../reference.ced"
+sgml-exposed-tags:nil
+sgml-local-catalogs:("/usr/lib/sgml/catalog")
+sgml-local-ecat-files:nil
+End:
+-->