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

[Régis Haubourg]

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/bfe74753/attachment.html>