Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 05D219FB326 for ; Sat, 30 Jun 2007 01:13:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 43710-02 for ; Sat, 30 Jun 2007 01:13:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from vps.newx.com.br (vps.newx.com.br [72.232.208.191]) by postgresql.org (Postfix) with ESMTP id 0A9119FB2D4 for ; Sat, 30 Jun 2007 01:13:16 -0300 (ADT) Received: from [201.21.202.199] (helo=[10.1.2.10]) by vps.newx.com.br with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.66) (envelope-from ) id 1I4TxS-0000zn-Fy; Fri, 29 Jun 2007 23:49:15 -0400 Message-ID: <4685D8C8.2070808@timbira.com> Date: Sat, 30 Jun 2007 01:15:04 -0300 From: Euler Taveira de Oliveira User-Agent: Thunderbird 1.5.0.10 (X11/20070301) MIME-Version: 1.0 To: David Fetter CC: Tom Lane , Susanne Ebrecht , pgsql-docs@postgresql.org Subject: Re: rename of a view References: <46839C05.7050307@miracee.de> <3450.1183040211@sss.pgh.pa.us> <20070629183219.GO7636@fetter.org> <20070630001653.GQ7636@fetter.org> In-Reply-To: <20070630001653.GQ7636@fetter.org> X-Enigmail-Version: 0.94.3.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - vps.newx.com.br X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - timbira.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/32 X-Sequence-Number: 4321 David Fetter wrote: pgsql-patches will be more appropriate for a patch. Could you post there so your patch won't be forget? > The attached patch and file implement and document > > ALTER [VIEW | SEQUENCE] RENAME TO > I didn't test your patch, but I think we could disallow ALTER TABLE to rename sequence and view because we have specific new commands for it or at least put a NOTICE saying such a thing. -- Euler Taveira de Oliveira http://www.timbira.com/