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" <[email protected]> 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 <[email protected]>: > >> 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 >> [email protected] >> 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
