Re: maintaining nested views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Maximilian Tyrtania <maximilian(dot)tyrtania(at)byte-employer(dot)de>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: maintaining nested views
Date: 2009-10-12 13:57:09
Message-ID: 7083.1255355829@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Maximilian Tyrtania <maximilian(dot)tyrtania(at)byte-employer(dot)de> writes:
> 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;

As of 8.4 you can add a column via CREATE OR REPLACE VIEW without that.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message UPGRADING NOTICE TO EMAIL USERS!!! 2009-10-13 08:30:20 DEAR EMAIL USER!!!
Previous Message Thom Brown 2009-10-12 07:09:42 Re: Lag and lead window functions order by weirdness