From: Mark Hollomon <mhh@mindspring.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
To: PostgreSQL-documentation <pgsql-docs@postgresql.org>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] Manual changes for ALTER TABLE OWNER
Date: Tue, 19 Dec 2000 17:41:59 -0500
Message-ID: <00121917415901.00689@jupiter.hollomon.fam> (raw)
In-Reply-To: <200012172007.PAA11878@candle.pha.pa.us>
References: <200012172007.PAA11878@candle.pha.pa.us>
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.patch (text/plain, 1.4K) download
*** 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>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: mhh@mindspring.com, pgman@candle.pha.pa.us, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Manual changes for ALTER TABLE OWNER
In-Reply-To: <00121917415901.00689@jupiter.hollomon.fam>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox