| From: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: view management |
| Date: | 2007-11-16 21:02:37 |
| Message-ID: | 200711161402.37167.pgsql@bluepolka.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Friday 16 November 2007 1:57 pm, Ed L. wrote:
> I have a question about view management...
>
> I often have need for views that reference views that
> reference views, and so on. When I need to make a small
> update to one of the views, I am faced with having to drop and
> recreate all dependent views even if the driving change just
> adds another column to the view, for example. I might have to
> drop and recreate many tens of views just to make a change to
> a single view. What a PITA. How do others manage this?
And before you tell me all about DROP VIEW ... CASCADE, please
note I'm not talking about that. I'm talking about the
difficulties of having to recreate all views in the entire
subtree of view dependencies just to change one minor aspect of
an independent view.
TIA...
Ed
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-11-16 21:03:07 | Re: [pgtranslation-translators] Call for translations |
| Previous Message | Tom Hart | 2007-11-16 21:02:34 | convert access sql to postgresql |