Re: query rewrite rules for updateable views?

["Jaime Casanova" <systemguards(at)gmail(dot)com>]

On 9/25/06, Markus Grabner <grabner(at)icg(dot)tu-graz(dot)ac(dot)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