[Qgis-community-team] Problem with editable postgis view in Qgis3

[Giuseppe Menetto]

Thank you Régis, 

I'll try to configure the dependecies and the 3.12 release. 

Thanks a lot for your work. 

Reguards 

Beppe 


Inviato da Workspace ONE Boxer 




Il giorno 13 Mar 2020 17:28, Régis Haubourg <regis.haubourg at gmail.com> ha scritto: 

Hi, yes this is a known issue, that was present also in 2.18 but less noticeable. The node tool refactor implied a cache that had difficulties to be refreshed if your triggers imply a change of the geometry when you commit in the database. 

We worked on this on 3.10. You can configure the layer dependencies in the layer options, so that you force the cache refresh on other layers or the layer itself. 

In 3.12 we also added a multithreading so that refreshing the cache is faster.  

Hope this helps 


Régis 



Le ven. 13 mars 2020 à 17:16, Giuseppe Menetto < giuseppe.menetto at csi.it> a écrit : 

hello, I'm using an editable view (idrographic graph ) created in postgis in a Qgis 3.4.12 LTR project.
The view with triggers works fine, I can manage features and attributes insert, update or delete , but after inserting or updating a new line it seems that Qgis doesn't refresh the spatial index, I see the feature, I can identify attributes but I can't change the geometry (e.g move vertex) or even snap to that with new features. If I open the view properties and then close, Qgis start a sort of indexing and everything works again. Does anybody know this problem? The same view in Qgis2.18 works without problems, but even in the 3.10 LTR the bug remains. Thanks


Giuseppe Menetto
___________________________________________________________
Il presente messaggio, corredato degli eventuali allegati, contiene informazioni da considerarsi strettamente riservate e confidenziali.
Ne è vietato l'uso improprio, la diffusione, la distribuzione o la riproduzione da parte di altre persone e/o entità diverse da quelle specificate.
Qualora lo abbiate ricevuto per errore, vi preghiamo di distruggere il messaggio, comunicando l'errata ricezione tramite il reply all'indirizzo mittente.

_______________________________________________ 
Qgis-community-team mailing list for organizing community resources such as documentation, translation etc.. 
Qgis-community-team at lists.osgeo.org 
https://lists.osgeo.org/mailman/listinfo/qgis-community-team 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-community-team/attachments/20200313/b1890aee/attachment.html>