Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3F44F9FC281 for ; Sat, 30 Jun 2007 02:33:18 -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 36885-01-10 for ; Sat, 30 Jun 2007 02:33:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mailbox.samurai.com (mailbox.samurai.com [205.207.28.82]) by postgresql.org (Postfix) with ESMTP id C47759FC282 for ; Sat, 30 Jun 2007 02:33:09 -0300 (ADT) Received: from localhost (mailbox.samurai.com [205.207.28.82]) by mailbox.samurai.com (Postfix) with ESMTP id 3616261D3A; Sat, 30 Jun 2007 01:33:09 -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 WID9P06iIGTf; Sat, 30 Jun 2007 01:33:07 -0400 (EDT) Received: from [192.168.1.167] (adsl-76-225-157-29.dsl.pltn13.sbcglobal.net [76.225.157.29]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by mailbox.samurai.com (Postfix) with ESMTP id 4354C61D29; Sat, 30 Jun 2007 01:33:07 -0400 (EDT) Subject: Re: rename of a view From: Neil Conway To: Tom Lane Cc: Euler Taveira de Oliveira , David Fetter , Susanne Ebrecht , pgsql-docs@postgresql.org In-Reply-To: <12776.1183177571@sss.pgh.pa.us> 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> Content-Type: text/plain Date: Fri, 29 Jun 2007 22:33:05 -0700 Message-Id: <1183181585.20942.1.camel@goldbach> 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: 200706/34 X-Sequence-Number: 4323 On Sat, 2007-30-06 at 00:26 -0400, Tom Lane wrote: > There is exactly 0 chance of that happening, because it's always worked > historically. Agreed, but I think the patch should disallow ALTER VIEW ... RENAME on a non-view, and ALTER SEQUENCE ... RENAME on a non-sequence. -Neil