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
*** 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>