Re: script to keep views "correct"? - Mailing list pgsql-general

From Tom Jenkins
Subject Re: script to keep views "correct"?
Date
Msg-id 1025201857.621.7.camel@asimov
Whole thread Raw
In response to Re: script to keep views "correct"?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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





pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Advocacy Idea.
Next
From: Christopher Murtagh
Date:
Subject: Permissions question