From 88bd306832f476987cf8166e8095756a5986d38b Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Thu, 15 Aug 2002 02:59:18 +0000
Subject: [PATCH] > Neil Conway <nconway@klamath.dyndns.org> writes: > > This
 patch improves the documentation of the UPDATE and ALTER TABLE > > commands
 to elaborate on the effect of specifying an "ONLY" clause. > > Unfortunately
 this is still only half the truth ... see the > SQL_INHERITANCE configuration
 variable.

Okay, I've attached an updated patch with more information on
SQL_INHERITANCE and inheritance behavior in prior releases.

Neil Conway
---
 doc/src/sgml/ref/alter_table.sgml | 12 ++++++++++--
 doc/src/sgml/ref/select.sgml      |  6 ++++--
 doc/src/sgml/ref/update.sgml      | 12 ++++++++++--
 3 files changed, 24 insertions(+), 6 deletions(-)

diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml
index 0bfe88cf54..61409861cf 100644
--- a/doc/src/sgml/ref/alter_table.sgml
+++ b/doc/src/sgml/ref/alter_table.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.48 2002/08/02 18:15:04 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.49 2002/08/15 02:59:18 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -60,7 +60,15 @@ ALTER TABLE <replaceable class="PARAMETER">table</replaceable>
       <term><replaceable class="PARAMETER"> table </replaceable></term>
       <listitem>
        <para>
-	The name (possibly schema-qualified) of an existing table to alter.
+	The name (possibly schema-qualified) of an existing table to
+	alter. If <literal>ONLY</> is specified, only that table is
+	altered. If <literal>ONLY</> is not specified, the table and all
+	its descendant tables (if any) are updated. <literal>*</> can be
+	appended to the table name to indicate that descendant tables are
+	to be scanned, but in the current version, this is the default
+	behavior.  (In releases before 7.1, <literal>ONLY</> was the
+	default behavior.)  The default can be altered by changing the
+	<option>SQL_INHERITANCE</option> configuration option.
        </para>
       </listitem>
      </varlistentry>
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml
index a1970c3e88..7a696491a6 100644
--- a/doc/src/sgml/ref/select.sgml
+++ b/doc/src/sgml/ref/select.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.55 2002/08/04 19:48:09 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.56 2002/08/15 02:59:18 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -131,7 +131,9 @@ where <replaceable class="PARAMETER">from_item</replaceable> can be:
 	tables (if any) are scanned.  <literal>*</> can be appended to the
 	table name to indicate that descendant tables are to be scanned, but
 	in the current version, this is the default behavior.  (In releases
-	before 7.1, <literal>ONLY</> was the default behavior.)
+	before 7.1, <literal>ONLY</> was the default behavior.)  The
+	default behavior can be modified by changing the
+	<option>SQL_INHERITANCE</option> configuration option.
        </para>
       </listitem>
      </varlistentry>
diff --git a/doc/src/sgml/ref/update.sgml b/doc/src/sgml/ref/update.sgml
index 439e11be4b..3825be5bc1 100644
--- a/doc/src/sgml/ref/update.sgml
+++ b/doc/src/sgml/ref/update.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/update.sgml,v 1.19 2002/04/23 02:07:16 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/update.sgml,v 1.20 2002/08/15 02:59:18 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -40,7 +40,15 @@ UPDATE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> SET <replacea
       <term><replaceable class="PARAMETER">table</replaceable></term>
       <listitem>
        <para>
-	The name (optionally schema-qualified) of an existing table.
+	The name (optionally schema-qualified) of an existing table. If
+	<literal>ONLY</> is specified, only that table is updated.  If
+	<literal>ONLY</> is not specified, the table and all its
+	descendant tables (if any) are updated. <literal>*</> can be
+	appended to the table name to indicate that descendant tables are
+	to be scanned, but in the current version, this is the default
+	behavior.  (In releases before 7.1, <literal>ONLY</> was the
+	default behavior.)  The default can be altered by changing the
+	<option>SQL_INHERITANCE</option> configuration option.
        </para>
       </listitem>
      </varlistentry>
-- 
2.40.0