From: David Fetter <david@fetter.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Neil Conway <neilc@samurai.com>
Cc: Euler Taveira de Oliveira <euler@timbira.com>
Cc: Susanne Ebrecht <miracee@miracee.de>
Cc: pgsql-docs@postgresql.org
Subject: Re: rename of a view
Date: Fri, 29 Jun 2007 22:40:44 -0700
Message-ID: <20070630054043.GR7636@fetter.org> (raw)
In-Reply-To: <15084.1183181782@sss.pgh.pa.us>
References: <46839C05.7050307@miracee.de>
<3450.1183040211@sss.pgh.pa.us>
<20070629183219.GO7636@fetter.org>
<20070630001653.GQ7636@fetter.org>
<4685D8C8.2070808@timbira.com>
<12776.1183177571@sss.pgh.pa.us>
<1183181585.20942.1.camel@goldbach>
<15084.1183181782@sss.pgh.pa.us>
On Sat, Jun 30, 2007 at 01:36:22AM -0400, Tom Lane wrote:
> Neil Conway <neilc@samurai.com> writes:
> > On Sat, 2007-30-06 at 00:26 -0400, Tom Lane wrote:
> >> There is exactly 0 chance of that happening, because it's always
> >> worked historically.
>
> > Agreed, but I think the patch should disallow ALTER VIEW ...
> > RENAME on a non-view, and ALTER SEQUENCE ... RENAME on a
> > non-sequence.
>
> No objection to that; it'd square with our treatment of TYPE and
> DOMAIN commands. What I'm wondering though is whether the whole
> patch has a reason to live at all, as compared to documenting
> someplace more prominent than now that ALTER TABLE works on views &
> sequences.
How could it be prominent short of documentation of the thing people
would expect, which is ALTER [SEQUENCE | VIEW] RENAME TO ... ? I
suppose we could document that they're actually done by ALTER TABLE,
but that just seems like a huge POLA violation, along with assuming
way too much knowledge of how sequences and views are implemented.
Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
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: david@fetter.org, tgl@sss.pgh.pa.us, neilc@samurai.com, euler@timbira.com, miracee@miracee.de
Subject: Re: rename of a view
In-Reply-To: <20070630054043.GR7636@fetter.org>
* 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