[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] query rewrite rules for updateable views?
From:       Markus Grabner <grabner () icg ! tu-graz ! ac ! at>
Date:       2006-09-25 8:04:51
Message-ID: 200609251004.51559.grabner () icg ! tu-graz ! ac ! at
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
[prev in list] [next in list] [prev in thread] [next in thread]