Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id F082E63230E for ; Mon, 12 Oct 2009 03:35:32 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65795-02 for ; Mon, 12 Oct 2009 06:35:25 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.188]) by mail.postgresql.org (Postfix) with ESMTP id 33EB962D46C for ; Mon, 12 Oct 2009 03:35:24 -0300 (ADT) Received: from [192.168.178.23] (brln-4dba27a8.pool.mediaWays.net [77.186.39.168]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0M9L3K-1N8nkH3On8-00CvRH; Mon, 12 Oct 2009 08:35:20 +0200 User-Agent: Microsoft-Entourage/11.4.0.080122 Date: Mon, 12 Oct 2009 08:35:18 +0200 Subject: maintaining nested views From: Maximilian Tyrtania To: "pgsql-sql@postgresql.org" Message-ID: Thread-Topic: maintaining nested views Thread-Index: AcpLBin/aNNe3rb5Ed6eRAAjMt4/tA== Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Provags-ID: V01U2FsdGVkX19xPmpUHK6S+wYHoTTCkRqLlLAs2viOu1qtVnt OEF2knaHoOrWIHNmFWBXHu34wfZaHfMvex3OAgZTsCx7iXEmRd 9IPxyt35yz8jdF1uuVbTDYxTZ3aYq2dJAmDOR+e2nqBgWsoLcq 9TQ== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.185 tagged_above=-10 required=5 tests=BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 200910/53 X-Sequence-Number: 33252 Quite often i find myself reluctant to nest views, because of the maintenance issues this usually involves. As you know, you can't easily alter the "lower level" views, because the higher level ones depend on them. So, to add a field to a lower level view one has to: drop view vw_lowlevel CASCADE; create view vw_lowlevel as .....; create view vw_highlevel as (it was); This can be quite cumbersome if there are many high level views and i don't want them to be altered (or at least not all of them). I'm just wondering if maybe someone has come up with a generic solution for this? Max