maintaining nested views

From: Maximilian Tyrtania <maximilian(dot)tyrtania(at)byte-employer(dot)de>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: maintaining nested views
Date: 2009-10-12 06:35:18
Message-ID: C6F89AC6.3BFE9%maximilian.tyrtania@byte-employer.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thom Brown 2009-10-12 07:09:42 Re: Lag and lead window functions order by weirdness
Previous Message Robert Paulsen 2009-10-11 15:04:18 Re: ERROR: null value in column "id" violates not-null constraint