Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eBKHhJ697222
	for <pgsql-docs@postgresql.org>; Wed, 20 Dec 2000 12:43:19 -0500 (EST)
	(envelope-from pgsql-docs-owner@postgresql.org)
Received: from granger.mail.mindspring.net (granger.mail.mindspring.net
	[207.69.200.148])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBJLdc624317;
	Tue, 19 Dec 2000 16:39:38 -0500 (EST)
	(envelope-from mhh@mindspring.com)
Received: from jupiter.hollomon.fam (user-2inikve.dialup.mindspring.com
	[165.121.83.238])
	by granger.mail.mindspring.net (8.9.3/8.8.5) with SMTP id QAA13003;
	Tue, 19 Dec 2000 16:39:28 -0500 (EST)
From: Mark Hollomon <mhh@mindspring.com>
Reply-To: mhh@mindspring.com
To: Bruce Momjian <pgman@candle.pha.pa.us>,
	PostgreSQL-documentation <pgsql-docs@postgresql.org>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] Manual changes for ALTER TABLE OWNER
Date: Tue, 19 Dec 2000 17:41:59 -0500
X-Mailer: KMail [version 1.1.99]
Content-Type: Multipart/Mixed; charset="US-ASCII";
	boundary="------------Boundary-00=_Z17UYKHU3EFO07XWQHMT"
References: <200012172007.PAA11878@candle.pha.pa.us>
In-Reply-To: <200012172007.PAA11878@candle.pha.pa.us>
MIME-Version: 1.0
Message-Id: <00121917415901.00689@jupiter.hollomon.fam>
X-Archive-Number: 200012/67
X-Sequence-Number: 114

--------------Boundary-00=_Z17UYKHU3EFO07XWQHMT
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 8bit

On Sunday 17 December 2000 15:07, Bruce Momjian wrote:
> We need additions to alter_table.sgml for the new OWNER option mention
> in the features list.

Here it is.

-- 
Mark Hollomon
--------------Boundary-00=_Z17UYKHU3EFO07XWQHMT
Content-Type: text/plain; name="doc.patch"
Content-Transfer-Encoding: 8bit
Content-Disposition: attachment; filename="doc.patch"

*** alter_table.sgml.orig	Tue Dec 19 17:32:47 2000
--- alter_table.sgml	Tue Dec 19 17:39:27 2000
***************
*** 36,41 ****
--- 36,43 ----
      RENAME TO <replaceable class="PARAMETER">newtable</replaceable>
  ALTER TABLE <replaceable class="PARAMETER">table</replaceable>
      ADD <replaceable class="PARAMETER">table constraint definition</replaceable>
+ ALTER TABLE <replaceable class="PARAMETER">table</replaceable>
+ 	OWNER TO <replaceable class="PARAMETER">new owner</replaceable> 
    </synopsis>
  
    <refsect2 id="R2-SQL-ALTERTABLE-1">
***************
*** 100,105 ****
--- 102,117 ----
         </para>
        </listitem>
       </varlistentry>
+ 
+      <varlistentry>
+       <term><replaceable class="PARAMETER">New user </replaceable></term>
+       <listitem>
+        <para>
+ 	The userid of the new owner of the table.
+        </para>
+       </listitem>
+      </varlistentry>
+ 
      </variablelist>
     </para>
    </refsect2>
***************
*** 158,163 ****
--- 170,177 ----
     The ADD <replaceable class="PARAMETER">table constraint definition</replaceable> clause 
     adds a new constraint to the table using the same syntax as <xref
     linkend="SQL-CREATETABLE" endterm="SQL-CREATETABLE-title">. 
+    The OWNER clause chnages the owner of the table to the user <replaceable class="PARAMETER">
+    new user</replaceable>.
    </para>
  
    <para>

--------------Boundary-00=_Z17UYKHU3EFO07XWQHMT--