<div dir="ltr"><div>Hi Magnus, thanks for the answer. </div><div><br></div>I think my rules are ok also because they work fine with QGIS 2.14.<div>The strange things is that the error say about an "<span style="font-size:12.8px">INSERT RETURNING" when I don't need any RETURING clause.</span><br></div><div><div>The problem happens only with INSERT rules. UPDATE and DELETE are ok.</div><div><br></div><div><br></div><div>this is my INSERT rule:</div><div><br></div><div><div>CREATE OR REPLACE RULE dif_spon_insert AS</div><div> ON INSERT TO sicod.v_dif_spon DO INSTEAD INSERT INTO sicod.dif_spon (padr_id, sigla_rile, prog_opera, localita, sponda, alt_min, alt_max, lung, tipologia, efficienza, stato, mat_massi, mat_c_secc, mat_c_int, mat_a_secc, mat_a_int, mat_gabbio, mat_cls, mat_legna, i_manuten, i_nessuna, i_prolung, i_pulizia, i_ricostru, i_sottomur, i_svuotam, so_dissest, so_interra, so_scalzat, so_sifonat, note, data_rilev, desc_fonte, font_elab, font_sopr, font_altro, geom)</div><div> VALUES (new.padr_id, new.sigla_rile, new.prog_opera, new.localita, new.sponda, new.alt_min, new.alt_max, new.lung, new.tipologia, new.efficienza, new.stato, new.mat_massi, new.mat_c_secc, new.mat_c_int, new.mat_a_secc, new.mat_a_int, new.mat_gabbio, new.mat_cls, new.mat_legna, new.i_manuten, new.i_nessuna, new.i_prolung, new.i_pulizia, new.i_ricostru, new.i_sottomur, new.i_svuotam, new.so_dissest, new.so_interra, new.so_scalzat, new.so_sifonat, new.note, new.data_rilev, new.desc_fonte, new.font_elab, new.font_sopr, new.font_altro, new.geom);</div></div><div><br></div></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2017-01-16 7:56 GMT+01:00 Karl-Magnus Jönsson <span dir="ltr"><<a href="mailto:Karl-Magnus.Jonsson@kristianstad.se" target="_blank">Karl-Magnus.Jonsson@kristianstad.se</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="SV" link="blue" vlink="purple">
<div class="m_-876443948220274784WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi!<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Are you sure it isn’t an issue with the view? I have a view with rules and it work in 2.18. When you have conditions in the rule you must have
another rule on the same event that is unconditional. Check the last paragraph in the description :
<a href="https://www.postgresql.org/docs/current/static/sql-createrule.html" target="_blank">https://www.postgresql.org/<wbr>docs/current/static/sql-<wbr>createrule.html</a><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">In my case I have a unconditional rule that does nothing:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">CREATE OR REPLACE RULE v_prislistor_upd_ins AS<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> ON UPDATE TO park.v_prislistor<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> WHERE <a href="http://old.id" target="_blank">old.id</a> IS NULL DO INSTEAD INSERT INTO park.priser (kod, pris, utforare)<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> VALUES (new.kod, new.pris, new.utforare);<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">CREATE OR REPLACE RULE v_prislistor_upd_nothing AS<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> ON UPDATE TO park.v_prislistor DO INSTEAD NOTHING;<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">CREATE OR REPLACE RULE v_prislistor_upd_upd AS<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> ON UPDATE TO park.v_prislistor<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> WHERE <a href="http://old.id" target="_blank">old.id</a> IS NOT NULL DO INSTEAD UPDATE park.priser SET pris = new.pris<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> WHERE <a href="http://priser.id" target="_blank">priser.id</a> = <a href="http://old.id" target="_blank">old.id</a>;<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d">Karl-Magnus Jönsson</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d">
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Från:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Qgis-user [mailto:<a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@<wbr>lists.osgeo.org</a>]
<b>För </b>Luca Lanteri<br>
<b>Skickat:</b> den 13 januari 2017 16:39<br>
<b>Till:</b> qgis-user<br>
<b>Ämne:</b> [Qgis-user] can't editing view using rules<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">Hi to all,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">starting fron QIS 2.16 I can't edit anymore postgres views with rules. When I try to insert a new feature I have this error [0]. All works fine with QGIS 2.14 <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Can anyone confirm the issue ?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Luca<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">[0]<u></u><u></u></p>
</div>
<div>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:9.5pt">Impossibile applicare le modifiche al vettore v_frane_pol_full<u></u><u></u></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:9.5pt"><u></u> <u></u></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:9.5pt">Errori: ERRORE: 1 geometria non aggiunta.<u></u><u></u></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:9.5pt">Errori della sorgente dati:<u></u><u></u></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:9.5pt">Errore PostGIS nell'aggiunta delle geometrie: ERROR: cannot perform INSERT RETURNING on relation "v_frane_pol_full"<u></u><u></u></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:9.5pt">HINT: You need an unconditional ON INSERT DO INSTEAD rule with a RETURNING clause.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div></div></div>
</div>
<br>______________________________<wbr>_________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/qgis-user</a><br></blockquote></div><br></div>