Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B979F9FA4E5 for ; Mon, 2 Jul 2007 22:35:23 -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 90812-03 for ; Mon, 2 Jul 2007 22:35:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mailbox.samurai.com (mailbox.samurai.com [205.207.28.82]) by postgresql.org (Postfix) with ESMTP id 228479FA2B2 for ; Mon, 2 Jul 2007 22:35:20 -0300 (ADT) Received: from localhost (mailbox.samurai.com [205.207.28.82]) by mailbox.samurai.com (Postfix) with ESMTP id BB29A61D4E; Mon, 2 Jul 2007 21:35:18 -0400 (EDT) X-Virus-Scanned: by amavisd-new at mailbox.samurai.com Received: from mailbox.samurai.com ([205.207.28.82]) by localhost (mailbox.samurai.com [205.207.28.82]) (amavisd-new, port 10024) with LMTP id zwyAe6hE9BZt; Mon, 2 Jul 2007 21:35:17 -0400 (EDT) Received: from [192.168.1.139] (204.11.227.33.static.etheric.net [204.11.227.33]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by mailbox.samurai.com (Postfix) with ESMTP id F081A61D4D; Mon, 2 Jul 2007 21:35:16 -0400 (EDT) Subject: Re: [DOCS] rename of a view From: Neil Conway To: David Fetter Cc: PostgreSQL Patches , Tom Lane , Euler Taveira de Oliveira , Susanne Ebrecht In-Reply-To: <20070701195528.GX7636@fetter.org> 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> Content-Type: text/plain Date: Mon, 02 Jul 2007 18:34:51 -0700 Message-Id: <1183426491.13154.14.camel@dell.linuxdev.us.dell.com> Mime-Version: 1.0 X-Mailer: Evolution 2.10.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/40 X-Sequence-Number: 3038 On Sun, 2007-07-01 at 12:55 -0700, David Fetter wrote: > 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. Applied with some fixes. Thanks for the patch. ALTER VIEW ... SET SCHEMA might be another worthwhile thing to add, for consistency. -Neil