: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
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
>
> 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
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
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
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
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
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 :