X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AAC0DD1B505 for ; Sat, 10 Jan 2004 07:55:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 74153-03 for ; Sat, 10 Jan 2004 03:54:57 -0400 (AST) Received: from trade-india.com (unknown [61.16.154.82]) by svr1.postgresql.org (Postfix) with SMTP id 37DECD1B4C2 for ; Sat, 10 Jan 2004 03:54:53 -0400 (AST) Received: (qmail 4913 invoked from network); 10 Jan 2004 07:54:54 -0000 Received: from system66.trade-india-local.com (HELO trade-india.com) (192.168.0.66) by system66.trade-india-local.com with SMTP; 10 Jan 2004 07:54:54 -0000 Message-ID: <3FFFAFCE.50005@trade-india.com> Date: Sat, 10 Jan 2004 13:24:54 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031021 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Adding a column to a VIEW which has dependent objects. Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/79 X-Sequence-Number: 16472 Dear PostgreSQL gurus, How do people extend a parent view which has lot of dependent views? The parent view cannot be dropped because that will require recreating a dozen of dependent views. Is there any workaround. Also is there an easy way of dumping the definitions of all the dependent views of a given object. Does information_schema helps here. Regds mallah.