Re: query rewrite rules for updateable views?

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)?

Thank you & kind regards,
Markus

--
Markus Grabner - Computer Graphics and Vision
Graz University of Technology, Inffeldgasse 16a/II, 8010 Graz, Austria
Phone: +43/316/873-5041, Fax: +43/316/873-5050
WWW: http://www.icg.tu-graz.ac.at/Members/grabner