Thread: query rewrite rules for updateable views?
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? 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
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! HTH, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
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
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