Re: [DOCS] rename of a view

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Neil Conway <neilc(at)samurai(dot)com>, Euler Taveira de Oliveira <euler(at)timbira(dot)com>, Susanne Ebrecht <miracee(at)miracee(dot)de>
Subject: Re: [DOCS] rename of a view
Date: 2007-07-01 19:55:28
Message-ID: 20070701195528.GX7636@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-patches

On Sat, Jun 30, 2007 at 01:48:51AM -0400, Tom Lane wrote:
> Neil Conway <neilc(at)samurai(dot)com> writes:
> > For the ALTER SEQUENCE case, I think it's also a little weird to
> > have an ALTER SEQUENCE command that modifies some of the
> > properties of a sequence, but not the sequence's name. While that
> > argument doesn't apply to ALTER VIEW at the moment, recent history
> > suggests that it may only be a matter of time before we need to
> > add an ALTER VIEW command anyway...
>
> OK, that's a fairly convincing argument. Fire away.
>
> (I'm still not sure you found all the relevant places in the
> documentation, however.)

Here's a new patch + file. This one allows ALTER [SEQUENCE | VIEW] to
work only on the respective database objects, but permits the old
ALTER TABLE syntax.

Cheers,
David.
--
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

Attachment Content-Type Size
alter_view_sequence_v2.diff text/plain 10.7 KB
alter_view.sgml text/sgml 2.3 KB

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Neil Conway 2007-07-02 04:03:45 Re: [DOCS] rename of a view
Previous Message Tom Lane 2007-06-30 05:48:51 Re: rename of a view

Browse pgsql-patches by date

  From Date Subject
Next Message Joe Conway 2007-07-01 20:03:22 Re: dblink connection security
Previous Message Tom Lane 2007-07-01 19:39:18 Re: dblink connection security