Re: [Qgis-user] can't editing view using rules

2017-01-18 Thread Luca Lanteri
:qgis-user-boun...@lists.osgeo.org] *För *Karl-Magnus > Jönsson > *Skickat:* den 17 januari 2017 17:32 > *Till:* Luca Lanteri > > *Kopia:* qgis-user > *Ämne:* Re: [Qgis-user] can't editing view using rules > > > > Could it be connected with the new feature to &quo

Re: [Qgis-user] can't editing view using rules

2017-01-18 Thread Karl-Magnus Jönsson
Integer (4 bytes). I'll have a look at the view. Karl-Magnus Jönsson Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Matthias Kuhn Skickat: den 18 januari 2017 09:21 Till: qgis-user@lists.osgeo.org Ämne: Re: [Qgis-user] can't editing view using rules Hi Karl-Magnus, What

Re: [Qgis-user] can't editing view using rules

2017-01-18 Thread Matthias Kuhn
> > Please let me know if you find a way to solve this better or a way to > turn this feature off in QGIS. > > > > *Karl-Magnus Jönsson* > > > > *Från:*Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] *För > *Karl-Magnus Jönsson > *Skickat:* den 17

Re: [Qgis-user] can't editing view using rules

2017-01-18 Thread Karl-Magnus Jönsson
Karl-Magnus Jönsson Skickat: den 17 januari 2017 17:32 Till: Luca Lanteri Kopia: qgis-user Ämne: Re: [Qgis-user] can't editing view using rules Could it be connected with the new feature to "execute expressions on the server side if possible"? Then you should get the new prima

Re: [Qgis-user] can't editing view using rules

2017-01-17 Thread Karl-Magnus Jönsson
nt_elab","font_sopr","font_altro") VALUES (st_multi(st_geomfromwkb($1::bytea,32632)),$2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,'0','0','0',NULL,'0','0','0','0','0','0','0','0','0','0','0','2000-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NUL

Re: [Qgis-user] can't editing view using rules

2017-01-17 Thread Luca Lanteri
ra","so_scalzat","so_sifonat","data_rilev","note","utente_crea","data_crea","utente_mod","data_mod","fonte","desc_fonte","font_elab","font_sopr","font_altro") VALUES (s

Re: [Qgis-user] can't editing view using rules

2017-01-16 Thread Luca Lanteri
Hi Magnus, thanks for the answer. I think my rules are ok also because they work fine with QGIS 2.14. The strange things is that the error say about an "INSERT RETURNING" when I don't need any RETURING clause. The problem happens only with INSERT rules. UPDATE and DELETE are ok. this is my

Re: [Qgis-user] can't editing view using rules

2017-01-15 Thread Karl-Magnus Jönsson
Hi! 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 :