Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 171999FBBF0 for ; Tue, 3 Jul 2007 03:38:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 33954-02 for ; Tue, 3 Jul 2007 03:38:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cronos.madness.at (madness.at [217.196.146.217]) by postgresql.org (Postfix) with ESMTP id 0CFD09FB855 for ; Tue, 3 Jul 2007 03:38:14 -0300 (ADT) Received: from mastermind.kaltenbrunner.cc ([83.215.233.60]) by cronos.madness.at with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1I5c1W-000545-4r; Tue, 03 Jul 2007 08:38:09 +0200 Message-ID: <4689EECF.9080902@kaltenbrunner.cc> Date: Tue, 03 Jul 2007 08:38:07 +0200 From: Stefan Kaltenbrunner User-Agent: Icedove 1.5.0.12 (X11/20070607) MIME-Version: 1.0 To: Neil Conway CC: Tom Lane , David Fetter , PostgreSQL Patches , Euler Taveira de Oliveira , Susanne Ebrecht Subject: Re: [DOCS] rename of a view References: <46839C05.7050307@miracee.de> <3450.1183040211@sss.pgh.pa.us> <20070629183219.GO7636@fetter.org> <20070630001653.GQ7636@fetter.org> <4685D8C8.2070808@timbira.com> <12776.1183177571@sss.pgh.pa.us> <1183181585.20942.1.camel@goldbach> <15084.1183181782@sss.pgh.pa.us> <1183182221.20942.8.camel@goldbach> <15362.1183182531@sss.pgh.pa.us> <20070701195528.GX7636@fetter.org> <1183426491.13154.14.camel@dell.linuxdev.us.dell.com> <27614.1183432429@sss.pgh.pa.us> <1183441827.9364.6.camel@goldbach> In-Reply-To: <1183441827.9364.6.camel@goldbach> X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/44 X-Sequence-Number: 3042 Neil Conway wrote: > On Mon, 2007-02-07 at 23:13 -0400, Tom Lane wrote: >> Er, was this on the agenda for 8.3? > > Well, it seemed fairly harmless to me (no behavioral changes and very > little new code, just syntax), so I didn't see a compelling reason to > delay applying it for a few months. But I can revert it if you'd prefer. hmm so now we have ALTER VIEW/SEQUENCE commands that can do a bit but not all of what ALTER TABLE can do (renaming columns of a VIEW or changing the owner for example). I agree in principle that having those functionality in ALTER VIEW/SEQUENCE is a good idea but only bringing in a bit of the required functionality which still does not solve the "uhm why do I need ALTER TABLE to manipulate a VIEW" months after the feature freeze sounds a bit wrong to me :-( Stefan