From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: questions on ALTER TABLE ... OWNER |
Date: | 2002-02-23 02:37:31 |
Message-ID: | 200202230237.g1N2bV206311@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Sorry, 7.3 only. Doc changes aren't really done for minor releases.
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Neil Conway wrote:
> On Tue, Feb 19, 2002 at 02:03:38PM -0500, Tom Lane wrote:
> > nconway(at)klamath(dot)dyndns(dot)org (Neil Conway) writes:
> > > Currently, ALTER TABLE ... OWNER will change the ownership of a table,
> > > view, sequence or index -- despite the fact that its name hints that it
> > > is only for 'altering tables'.
> >
> > > 1) Is this behavior optimal? There is clearly a need to change the
> > > ownership of relations other than tables, but it seems to me that
> > > pushing this functionality into ALTER TABLE is unintuitive.
> >
> > > On the other hand, creating ALTER INDEX ... OWNER, ALTER SEQUENCE ...
> > > OWNER, etc. seems like overkill.
> >
> > Definitely overkill.
>
> You're probably right -- although there is a symmetry between 'create
> sequence', 'alter sequence', and 'drop sequence', rather than 'create
> sequence', 'alter table' and 'drop sequence'.
>
> BTW, the same semantic problems also apply to ALTER TABLE ... rename.
>
> > I'd say tweak the docs and leave the code alone.
>
> Okay, fixed. I also corrected another minor inaccuracy in the ALTER
> TABLE docs.
>
> Bruce/Tom: Please apply for 7.2.1 and 7.3.
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <neilconway(at)rogers(dot)com>
> PGP Key ID: DB3C29FC
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-02-23 02:48:03 | Patches split from 7.3 queue |
Previous Message | Bruce Momjian | 2002-02-23 02:36:56 | Re: pg_dump: use ALTER TABLE for PKs |