| 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
| 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 |