Re: script to keep views "correct"?

On Thu, 2002-06-27 at 13:34, Richard Huxton wrote:
> On Thursday 27 Jun 2002 3:25 pm, Tom Jenkins wrote:
> > Hello all,
> > is there a script somewhere that ensures that changing a view that other
> > views depend on, will recreate those other views?
> > same thing with functions/triggers
>
> I believe there's work going on to create a dependencies table, but of course
> that's a lot of individual changes to make sure everything writes to it, so I
> don't think it's imminent.

that will be very nice.

>
> I try to keep all my source SQL/functions outside the database and manage them
> with make. Not ideal, but the best I've come up with so far.
>

hrmmm... haven't thought about make

although pg_rewrite seems to have the info i want; i just have to parse
it

> - Richard Huxton
--

Tom Jenkins
Development InfoStructure
http://www.devis.com