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: Susanne Ebrecht <miracee(at)miracee(dot)de>, pgsql-docs(at)postgresql(dot)org
Subject: Re: rename of a view
Date: 2007-06-30 00:16:53
Message-ID: 20070630001653.GQ7636@fetter.org (view raw or flat)
Thread:
Lists: pgsql-docspgsql-patches
On Fri, Jun 29, 2007 at 11:32:19AM -0700, David Fetter wrote:
> On Thu, Jun 28, 2007 at 10:16:51AM -0400, Tom Lane wrote:
> > Susanne Ebrecht <miracee(at)miracee(dot)de> writes:
> > > that works, but there is no hint at the documentation, that you
> > > can rename a view via alter table.
> > 
> > It is mentioned someplace (don't remember where).  Where would you
> > have expected to find it?
> 
> I'd expect to find it in an ALTER VIEW document.
> 
> Cheers,
> D

The attached patch and file implement and document

    ALTER [VIEW | SEQUENCE] RENAME TO

The file goes in doc/src/sgml/ref and the patch should just apply to
CVS HEAD.

Thanks to Neil Conway for all the help putting this together :)

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

Attachment: alter_view.sgml
Description: text/sgml (2.3 KB)

In response to

Responses

pgsql-docs by date

Next:From: Euler Taveira de OliveiraDate: 2007-06-30 04:15:04
Subject: Re: rename of a view
Previous:From: Susanne EbrechtDate: 2007-06-29 18:32:44
Subject: Re: rename of a view

pgsql-patches by date

Next:From: Greg SmithDate: 2007-06-30 01:30:55
Subject: Re: Checkpoint logging, revised patch
Previous:From: Tom LaneDate: 2007-06-30 00:05:31
Subject: Re: Checkpoint logging, revised patch

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