Can't insert&update data in PostGis Views

[PFerro]

Hi,

When I try to update or insert data which are in Postgis Views it's not possible (they all have write permissions and if I do the some action at QGIS works).

When I do the same action on Postgis Tables it works as expected.

Tested at Lizmap 2.10 and 2.11

Regards, Pedro

[PFerro]

Hi Michael,

QGIS Sever: 2.6.0.1 QGIS Desktop: 2.6 and 2.4 (tried with both and the result is same)

regards, Pedro

[rldhont]

I can't reproduce the issue.

I created a vue base on a table with a trigger and I was able to update through the view.

[jancelin]

No problems for me on Lizmap 2.10 or 11beta. All my views working . insert update delete with triggers working also.We need more information on the view

[jancelin]

Have you registered your login password postgis in qgis, so in your .qgis file?

[rldhont]

Has been fixed and validated by @jancelin

[slarosa]

I have a similar error in 3.0b4 (e45489d),

Failed to load resource: the server responded with a status of 500 (Internal Jelix Error)

on edit/add/delete geometry in a postgis (point) table.

This is happening on a localhost server, Chrome and OSX.

[slarosa]

I created a simple project for testing: http://lrssvt.ns0.it/h2o/lizmap/www/index.php/view/

[josemvm]

hi,

i think that I had a similar case... because the GID field wasn't published through WFS

[slarosa]

@josemvm Did you manage to figure out a way to solve the problem?

[josemvm]

in my case, it was a simple project configuration trouble, in layer properties/fields

[slarosa]

unfortunately it does not work for me, all fields have the check in my case.