Received: from ns1.greatbridge.com (ns1.greatbridge.com [216.54.52.10])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f25H6lx09048
	for <pgsql-docs@postgresql.org>; Mon, 5 Mar 2001 12:06:47 -0500 (EST)
	(envelope-from pierce@greatbridge.com)
Received: (from daemon@localhost)
	by ns1.greatbridge.com (8.9.3/8.9.3) id MAA02265;
	Mon, 5 Mar 2001 12:10:00 -0500
Received: from UNKNOWN(216.54.52.226), claiming to be "greatbridge.com"
	via SMTP by ns1, id smtpdCFUeiW; Mon Mar  5 12:09:55 2001
Message-ID: <3AA3C833.383FEFFB@greatbridge.com>
Date: Mon, 05 Mar 2001 12:09:07 -0500
From: Pierce Tyler <pierce@greatbridge.com>
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: lockhart@fourpalms.org, pgsql-docs@postgresql.org
Subject: Reference Guide diffs
Content-Type: multipart/mixed; boundary="------------9ADE5A40DF8A72EDB6B0A48B"
X-Archive-Number: 200103/10
X-Sequence-Number: 441

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

I'm attaching several minor diffs (mostly typos) that impact the
Reference Guide.

Pierce

-- 
--------------------------------------------------------------
Pierce Tyler                    | e: pierce@greatbridge.com
Technical Writer                | p: (757)233-5544
Great Bridge, LLC               | w: www.greatbridge.com
                                     www.greatbridge.org
--------------9ADE5A40DF8A72EDB6B0A48B
Content-Type: text/plain; charset=us-ascii; name="alter_table.sgml.diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="alter_table.sgml.diff"

*** ref-symlink/alter_table.sgml	Sat Feb 10 11:41:30 2001
--- alter_table.sgml	Mon Mar  5 09:38:56 2001
***************
*** 107,113 ****
        <term><replaceable class="PARAMETER">New user </replaceable></term>
        <listitem>
         <para>
! 	The userid of the new owner of the table.
         </para>
        </listitem>
       </varlistentry>
--- 107,113 ----
        <term><replaceable class="PARAMETER">New user </replaceable></term>
        <listitem>
         <para>
! 	The user name of the new owner of the table.
         </para>
        </listitem>
       </varlistentry>

--------------9ADE5A40DF8A72EDB6B0A48B
Content-Type: text/plain; charset=us-ascii; name="comment.sgml.diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="comment.sgml.diff"

*** ref-symlink/comment.sgml	Sat Jan 20 15:59:29 2001
--- comment.sgml	Mon Mar  5 09:42:41 2001
***************
*** 101,107 ****
    <para>
     <command>COMMENT</command> adds a comment to an object that can be 
      easily retrieved with <application>psql's</application>
!     <emphasis>\dd</emphasis> or <emphasis>\d+</emphasis> commands.
      To remove a comment, use <literal>NULL</literal>.
      Comments are automatically dropped when the object is dropped.
    </para>
--- 101,107 ----
    <para>
     <command>COMMENT</command> adds a comment to an object that can be 
      easily retrieved with <application>psql's</application>
!     <emphasis>\dd</emphasis>, <emphasis>\d+</emphasis>, or <emphasis>\l+</emphasis>commands.
      To remove a comment, use <literal>NULL</literal>.
      Comments are automatically dropped when the object is dropped.
    </para>

--------------9ADE5A40DF8A72EDB6B0A48B
Content-Type: text/plain; charset=us-ascii; name="create_type.sgml.diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="create_type.sgml.diff"

*** ref-symlink/create_type.sgml	Sat Jan 13 18:58:55 2001
--- create_type.sgml	Mon Mar  5 10:01:53 2001
***************
*** 298,304 ****
  
    <para>
     The <replaceable class="parameter">storage</replaceable> keyword
!    allows selection of TOAST storage method for variable-length data types
     (only <literal>plain</literal> is allowed for fixed-length types).
     <literal>plain</literal> disables TOAST for the data type: it will always
     be stored in-line and not compressed.
--- 298,304 ----
  
    <para>
     The <replaceable class="parameter">storage</replaceable> keyword
!    allows selection of The Oversized-Attribute Storage Technique (TOAST) for variable-length data types
     (only <literal>plain</literal> is allowed for fixed-length types).
     <literal>plain</literal> disables TOAST for the data type: it will always
     be stored in-line and not compressed.

--------------9ADE5A40DF8A72EDB6B0A48B
Content-Type: text/html; charset=us-ascii; name="pg_config-ref.sgml.diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="pg_config-ref.sgml.diff"

*** ref-symlink/pg_config-ref.sgml	Sat Nov 11 18:01:45 2000
--- pg_config-ref.sgml	Mon Mar  5 10:42:25 2001
***************
*** 32,38 ****
   <refsect1>
    <title>Description</>
    <para>
!    The <application>pg_config</> stores and provides configuration parameters
     of the currently installed version of <productname>PostgreSQL</>. It is
     intended, for example, to be used by software packages that want to interface
     to <productname>PostgreSQL</> in order to find the respective header files
--- 32,38 ----
   <refsect1>
    <title>Description</>
    <para>
!    The <application>pg_config</> utility provides configuration parameters
     of the currently installed version of <productname>PostgreSQL</>. It is
     intended, for example, to be used by software packages that want to interface
     to <productname>PostgreSQL</> in order to find the respective header files

--------------9ADE5A40DF8A72EDB6B0A48B
Content-Type: text/plain; charset=us-ascii; name="pg_dump.sgml.diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="pg_dump.sgml.diff"

[ptyler@greatbridge_dev1 mar5]$ diff -c ref-symlink/pg_dump.sgml pg_dump.sgml 
*** ref-symlink/pg_dump.sgml	Mon Dec 25 18:15:26 2000
--- pg_dump.sgml	Fri Mar  2 17:28:50 2001
***************
*** 78,84 ****
        <term>-b</term>
        <listitem>
         <para>
! 	Dump BLOB data.
         </para>
        </listitem>
       </varlistentry>
--- 78,84 ----
        <term>-b</term>
        <listitem>
         <para>
! 	Dump data and BLOB data.
         </para>
        </listitem>
       </varlistentry>

--------------9ADE5A40DF8A72EDB6B0A48B
Content-Type: text/plain; charset=us-ascii; name="pg_dumpall.sgml.diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="pg_dumpall.sgml.diff"

*** ref-symlink/pg_dumpall.sgml	Sat Feb 10 20:41:00 2001
--- pg_dumpall.sgml	Mon Mar  5 09:25:48 2001
***************
*** 55,61 ****
     Since <application>pg_dumpall</application> reads tables from all
     databases you will most likely have to connect as a database
     superuser in order to produce a complete dump.  Also you will need
!    superuser priviledges to execute the saves script in order to be
     allowed to add users and groups, and to create databases.
    </para>
  
--- 55,61 ----
     Since <application>pg_dumpall</application> reads tables from all
     databases you will most likely have to connect as a database
     superuser in order to produce a complete dump.  Also you will need
!    superuser privileges to execute the saved script in order to be
     allowed to add users and groups, and to create databases.
    </para>
  
***************
*** 146,152 ****
     (It is not important to which database you connect here since the
     script file created by <application>pg_dumpall</application> will
     contain the appropriate commands to create and connect to the saved
!    databases.
    </para>
   </refsect1>
  
--- 146,152 ----
     (It is not important to which database you connect here since the
     script file created by <application>pg_dumpall</application> will
     contain the appropriate commands to create and connect to the saved
!    databases.)
    </para>
   </refsect1>

--------------9ADE5A40DF8A72EDB6B0A48B
Content-Type: text/plain; charset=us-ascii; name="pg_restore.sgml.diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="pg_restore.sgml.diff"

*** ref-symlink/pg_restore.sgml	Mon Dec 25 18:15:26 2000
--- pg_restore.sgml	Mon Mar  5 09:31:43 2001
***************
*** 428,440 ****
     The most flexible output file format is the new 'custom' format (-Fc). 
It allows for
     selection and reordering of all archived items, and is compressed by de
fault. The TAR
     format (-Ft) is not compressed and it is not possible to reorder
!    data load, but it is otherwise quite flexible.
    </para>
  
    <para>
     To reorder the items, it is first necessary to dump the contents of the
 archive:
     <programlisting>
!     $ pg_restore acrhive.file --list > archive.lis
     </programlisting>
     This file consists of a header and one line for each item, eg.
     <programlisting>
--- 428,440 ----
     The most flexible output file format is the new 'custom' format (-Fc). 
It allows for
     selection and reordering of all archived items, and is compressed by de
fault. The TAR
     format (-Ft) is not compressed and it is not possible to reorder
!    data when loading, but it is otherwise quite flexible.
    </para>
  
    <para>
     To reorder the items, it is first necessary to dump the contents of the
 archive:
     <programlisting>
!     $ pg_restore archive.file --list > archive.lis
     </programlisting>
     This file consists of a header and one line for each item, eg.
     <programlisting>

--------------9ADE5A40DF8A72EDB6B0A48B
Content-Type: text/plain; charset=us-ascii; name="set.sgml.diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="set.sgml.diff"

*** ref-symlink/set.sgml	Thu Oct  5 15:48:19 2000
--- set.sgml	Mon Mar  5 10:09:36 2001
***************
*** 196,202 ****
  	    The value for the seed to be used by the
  	    <function>random</function> function. Allowed
  	    values are floating point numbers between 0 and 1, which
! 	    are then multiplied by 2^31-1. This product will
  	    silently overflow if a number outside the range is used.
  	   </para>
  
--- 196,202 ----
  	    The value for the seed to be used by the
  	    <function>random</function> function. Allowed
  	    values are floating point numbers between 0 and 1, which
! 	    are then multiplied by RAND_MAX. This product will
  	    silently overflow if a number outside the range is used.
  	   </para>

--------------9ADE5A40DF8A72EDB6B0A48B--