From: Maximilian Tyrtania <maximilian.tyrtania@byte-employer.de>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: maintaining nested views
Date: Mon, 12 Oct 2009 08:35:18 +0200
Message-ID: <C6F89AC6.3BFE9%maximilian.tyrtania@byte-employer.de> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maximilian.tyrtania@byte-employer.de
Subject: Re: maintaining nested views
In-Reply-To: <C6F89AC6.3BFE9%maximilian.tyrtania@byte-employer.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox