| 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: | Whole Thread | Raw Message | 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 |
| 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 |
| 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 |