pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedManual changes for ALTER TABLE OWNER
3+ messages / 2 participants
[nested] [flat]
* Manual changes for ALTER TABLE OWNER
@ 2000-12-17 20:07 Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Bruce Momjian @ 2000-12-17 20:07 UTC (permalink / raw)
To: pgsql-docs; PostgreSQL-development <pgsql-hackers@postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [HACKERS] Manual changes for ALTER TABLE OWNER
@ 2000-12-19 22:41 Mark Hollomon <mhh@mindspring.com>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Mark Hollomon @ 2000-12-19 22:41 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-docs; PostgreSQL-development <pgsql-hackers@postgresql.org>
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>
* Re: [HACKERS] Manual changes for ALTER TABLE OWNER
@ 2000-12-20 03:19 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Mark Hollomon <mhh@mindspring.com>
0 siblings, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 2000-12-20 03:19 UTC (permalink / raw)
To: mhh@mindspring.com; +Cc: pgsql-docs; PostgreSQL-development <pgsql-hackers@postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-12-20 03:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-17 20:07 Manual changes for ALTER TABLE OWNER Bruce Momjian <pgman@candle.pha.pa.us>
2000-12-19 22:41 ` Mark Hollomon <mhh@mindspring.com>
2000-12-20 03:19 ` Bruce Momjian <pgman@candle.pha.pa.us>
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