Hi,
i'am using QGIS to manage postgis data. I have one table containig geometry
data and one table containing alfanumeric data. The two tables are linked
together by a view. I created a rule on the view because I need to call a
function during the delete event.
here an example:
CREATE OR REPLACE RULE my_rule_del AS
ON DELETE TO my_view DO INSTEAD SELECT my_func();
QGIS reads and modifies data on the view "my_view".
When the QGIS user deletes some features and than try to save, an error is
generated. QGIS tries to execute an sql statement "DELETE FROM my_view WHERE
..." which returns something unexpected by QGIS.
Using postgresql 8.4 it works well. The problem is generaed only using
postgresql 9.
if I use the following rule:
CREATE OR REPLACE RULE my_rule_del AS
ON DELETE TO my_view DO INSTEAD DELETE FROM my_table WHERE ...;
It works fine in both postgresql version.
I think that the problem is due to what is returned by the rule. Calling a
function in the rule I need to use "SELECT my_func()" SQL statement which
returns to QGIS a recordset or something different from what is returned by
DELETE SQL statement.
How can I control the value returned by the rule ?
Thanks in advance.
Poltini Roberto
________________________________
Il Gruppo Iren La invita a prendere visione del Bilancio di Sostenibilita' 2012
(http://www.gruppoiren.it/bilancio_sfogliabile/index.html) e a visitare la
sezione Sostenibilit? del sito internet di Gruppo
(http://www.gruppoiren.it/sostenibilita.asp). Con tali strumenti la Societa'
intende intensificare i rapporti con i propri stakeholder attraverso un canale
di comunicazione chiaro e trasparente.
Le informazioni contenute nella presente comunicazione e i relativi allegati
possono essere riservate e sono, comunque, destinate esclusivamente alle
persone o alla Societ? sopraindicati. La diffusione, distribuzione e/o
copiatura del documento trasmesso da parte di qualsiasi soggetto diverso dal
destinatario ? proibita, sia ai sensi dell'art. 616 c.p. , che ai sensi del
D.Lgs. n. 196/2003. Se avete ricevuto questo messaggio per errore, vi preghiamo
di distruggerlo e di informare immediatamente il mittente.
________________________________
Iren is pleased to announce the Sustainability Report 2012 at
http://www.gruppoiren.it/bilancio_sfogliabile/index.html. We invite you to
visit the Sustainability website at http://www.gruppoiren.it/sostenibilita.asp.
Sustainability Report is a part of our strategy for building trustful
relationships with stakeholders.
The information in this e-mail (which includes any files transmitted with it)
is confidential and may also be legally privileged. It is intended for the
addressee only. Access to this e-mail by anyone else is unauthorised. It is not
to be relied upon by any person other than the addressee, except with our prior
written approval. If no such approval is given, we will not accept any
liability (in negligence or otherwise) arising from any third party acting.
Unauthorised recipients are required to maintain confidentiality. If you have
received this e-mail in error please notify us immediately, destroy any copies
and delete it from your computer system. Any use, dissemination, forwarding,
printing or copying of this e-mail is prohibited.
________________________________
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
