Skip site navigation (1) Skip section navigation (2)

Re: rename of a view

From: David Fetter <david(at)fetter(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Neil Conway <neilc(at)samurai(dot)com>,Euler Taveira de Oliveira <euler(at)timbira(dot)com>,Susanne Ebrecht <miracee(at)miracee(dot)de>, pgsql-docs(at)postgresql(dot)org
Subject: Re: rename of a view
Date: 2007-06-30 05:40:44
Message-ID: 20070630054043.GR7636@fetter.org (view raw or flat)
Thread:
Lists: pgsql-docspgsql-patches
On Sat, Jun 30, 2007 at 01:36:22AM -0400, Tom Lane wrote:
> Neil Conway <neilc(at)samurai(dot)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(at)fetter(dot)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

In response to

pgsql-docs by date

Next:From: Neil ConwayDate: 2007-06-30 05:43:41
Subject: Re: rename of a view
Previous:From: Tom LaneDate: 2007-06-30 05:36:22
Subject: Re: rename of a view

pgsql-patches by date

Next:From: Neil ConwayDate: 2007-06-30 05:43:41
Subject: Re: rename of a view
Previous:From: Tom LaneDate: 2007-06-30 05:36:22
Subject: Re: rename of a view

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group