<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.StileMessaggioDiPostaElettronica17
{font-family:"Calibri","sans-serif";
color:windowtext}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:70.85pt 2.0cm 2.0cm 2.0cm}
div.WordSection1
{}
-->
</style>
</head>
<body lang="IT" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi,</p>
<p class="MsoNormal"> 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.</p>
<p class="MsoNormal">here an example:</p>
<p class="MsoNormal">CREATE OR REPLACE RULE my_rule_del AS</p>
<p class="MsoNormal"> ON DELETE TO my_view DO INSTEAD SELECT my_func();</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">QGIS reads and modifies data on the view "my_view".</p>
<p class="MsoNormal">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.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Using postgresql 8.4 it works well. The problem is generaed only using postgresql 9.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">if I use the following rule:</p>
<p class="MsoNormal">CREATE OR REPLACE RULE my_rule_del AS</p>
<p class="MsoNormal"> ON DELETE TO my_view DO INSTEAD DELETE FROM my_table WHERE ...;</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">It works fine in both postgresql version.</p>
<p class="MsoNormal">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.</p>
<p class="MsoNormal">How can I control the value returned by the rule ?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks in advance.</p>
<p class="MsoNormal" style=""><span style="font-size:12.0pt; font-family:"Times New Roman","serif"">Poltini Roberto
<br>
<br>
</span></p>
</div>
<div style="font-size:9pt; font-family:'Calibri',sans-serif"><font color="gray">
<div class="MsoNormal" align="center" style="text-align:center"><span style="color:gray">
<hr size="1" width="100%" align="center">
</span></div>
Il Gruppo Iren La invita a prendere visione del Bilancio di Sostenibilita' 2012 (<a href="http://www.gruppoiren.it/bilancio_sfogliabile/index.html">http://www.gruppoiren.it/bilancio_sfogliabile/index.html</a>) e a visitare la sezione Sostenibilità del sito
internet di Gruppo (<a href="http://www.gruppoiren.it/sostenibilita.asp">http://www.gruppoiren.it/sostenibilita.asp</a>). Con tali strumenti la Societa' intende intensificare i rapporti con i propri stakeholder attraverso un canale di comunicazione chiaro
e trasparente. <br>
<br>
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.<br>
<div class="MsoNormal" align="center" style="text-align:center"><span style="color:gray">
<hr size="1" width="100%" align="center">
</span></div>
Iren is pleased to announce the Sustainability Report 2012 at <a href="http://www.gruppoiren.it/bilancio_sfogliabile/index.html">
http://www.gruppoiren.it/bilancio_sfogliabile/index.html</a>. We invite you to visit the Sustainability website at
<a href="http://www.gruppoiren.it/sostenibilita.asp">http://www.gruppoiren.it/sostenibilita.asp</a>. Sustainability Report is a part of our strategy for building trustful relationships with stakeholders.
<br>
<br>
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.<br>
<div class="MsoNormal" align="center" style="text-align:center"><span style="color:gray">
<hr size="1" width="100%" align="center">
</span></div>
</font></div>
</body>
</html>