[Qgis-user] Lizmap - can't insert&update data in PostGis Views

[Alexandre Neto]

Hello Pedro,

according to Fred Lehoney (I haven't test it) the latest version of
postgres alows to edit simple views (that is, simple selects on a single
table, with no aggregate functions, or functions around fields).

But, if you are using 9.2 or you have any of those conditions, you can
always use triggers to redirect your view edits to the original tables.

I don't have an example now, but I can give you one tomorrow.

Best regards,
Abraço,

Alexandre Neto
Em 25/11/2014 13:06, "Sergio Gollino" <gollinosergio at gmail.com> escreveu:

> That's not a bug.
>
> You can't insert data on a view, because a view, it's just a select of
> something (one or more other tables) so, if you have to insert something
> inside a view, you have to insert it in the original table.
>
> Regards
>
> Sergio
>
> 2014-11-25 11:20 GMT+01:00 Pedro <pedro.ferro at gmail.com>:
>
>> Hi,
>>
>> When I try to update or insert data which are in Postgis Views is not
>> possible (they all have write permissions and if I do the some action at
>> QGIS works).
>>
>> <http://osgeo-org.1560.x6.nabble.com/file/n5174737/Capturar.png>
>>
>>
>> When I do the same action on Postgis Tables it works as expected.
>>
>>
>> P.S. - I open an Issue at Lizmap GitHub because it seems like a bug
>>
>>
>>
>> --
>> View this message in context:
>> http://osgeo-org.1560.x6.nabble.com/Lizmap-can-t-insert-update-data-in-PostGis-Views-tp5174737.html
>> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
>
>
> --
> Sergio Gollino
>
> Questo messaggio, comprensivo di eventuali allegati, è ad uso esclusivo
> del destinatario e potrebbe contenere  informazioni riservate; se è stato
> recapitato per errore ci scusiamo per l'accaduto e Vi invitiamo
> cortesemente a darcene notizia provvedendo alla sua distruzione.
> Vi ricordiamo che la diffusione, l'utilizzo e/o la conservazione dei dati
> ricevuti per errore costituiscono violazione alle disposizioni del D.Lgs.
> n. 196/2003 "Codice in materia di protezione dei dati personali".
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141125/891edbcc/attachment.html>