Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9321B9FB809 for ; Fri, 29 Jun 2007 15:32:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 35520-02-2 for ; Fri, 29 Jun 2007 15:32:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fetter.org (start.fetter.org [66.92.188.65]) by postgresql.org (Postfix) with ESMTP id 9E11A9FB6A9 for ; Fri, 29 Jun 2007 15:32:21 -0300 (ADT) Received: by fetter.org (Postfix, from userid 500) id A8390FBC758; Fri, 29 Jun 2007 11:32:19 -0700 (PDT) Date: Fri, 29 Jun 2007 11:32:19 -0700 From: David Fetter To: Tom Lane Cc: Susanne Ebrecht , pgsql-docs@postgresql.org Subject: Re: rename of a view Message-ID: <20070629183219.GO7636@fetter.org> References: <46839C05.7050307@miracee.de> <3450.1183040211@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3450.1183040211@sss.pgh.pa.us> User-Agent: Mutt/1.5.14 (2007-02-12) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/29 X-Sequence-Number: 4318 On Thu, Jun 28, 2007 at 10:16:51AM -0400, Tom Lane wrote: > Susanne Ebrecht 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 -- David Fetter 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