Participants
Bruce Momjian
Bruce Momjian
Mark Hollomon
Mark Hollomon
Attachments
Thread Outline
#1Bruce MomjianBruce Momjian
Dec 17, 2000
#2Mark Hollomon↳Mark Hollomonto Bruce Momjian (#1)
Dec 19, 2000
#3Bruce Momjian↳Bruce Momjianto Mark Hollomon (#2)
Dec 20, 2000

Manual changes for ALTER TABLE OWNER

Started by Bruce Momjianabout 25 years ago3 messages
#1Bruce Momjian
Bruce Momjian
pgman@candle.pha.pa.us

We need additions to alter_table.sgml for the new OWNER option mention
in the features list.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
#2Mark Hollomon
Mark Hollomon
mhh@mindspring.com
In reply to: Bruce Momjian (#1)
1 attachment(s)
Re: [HACKERS] Manual changes for ALTER TABLE OWNER

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

Attachments:

doc.patchtext/plain; name=doc.patchDownload
*** 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>
#3Bruce Momjian
Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Mark Hollomon (#2)
Re: [HACKERS] Manual changes for ALTER TABLE OWNER

Thanks. Applied.

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

[ Attachment, skipping... ]

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
← Back to Topics