view management - Mailing list pgsql-general

From Ed L.
Subject view management
Date
Msg-id 200711161357.24448.pgsql@bluepolka.net
Whole thread Raw
Responses Re: view management  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: view management  ("Ed L." <pgsql@bluepolka.net>)
Re: view management  (Jorge Godoy <jgodoy@gmail.com>)
List pgsql-general
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?

TIA.
Ed

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: pl-pgsql "return set of..." "return next..." performance question
Next
From: "Joshua D. Drake"
Date:
Subject: Re: view management