Re: query rewrite rules for updateable views?

On 9/25/06, Markus Grabner <grabner@icg.tu-graz.ac.at> wrote:
> Am Montag, 25. September 2006 07:09 schrieb A. Kretschmer:
> > am  Mon, dem 25.09.2006, um  2:56:47 +0200 mailte Markus Grabner folgendes:
> > >     Hi!
> > >
> > >     As far as I understand, one can simulate updateable views in
> > > PostgreSQL by providing appropriate query rewrite rules. Is there any
> > > tool to automatically create these rules for a given set of table and
> > > view definitions?
> >
> > Bernd Helme is developing this, take a look at
> > http://www.oopsware.de/pgsql_viewupdate.html, but this is *NOT* intended
> > for production use!
> Thanks for the hint, this looks promising! However, I was looking for a
> solution which I can use as "addon" to an existing PostgreSQL installation
> (e.g., a script to run manually after each table/view creation or
> modification) until this feature is fully integrated as tested. Any ideas
> about that (or can Bernd's code be used this way)?
>

no, it can't. it must be patched in the code and recompile postgres...

AFAIK, there's no such tool. you will have to create the rules at hand

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook