Re: [QGIS-Developer] WFS-T, postgis and triggers

2020-11-02 Thread Régis Haubourg
Hi, Le lun. 2 nov. 2020 à 07:29, Denis Rouzaud a écrit : > But couldn't we just add an option to the layer to re-fetch the data once > inserted? > > I think the layer dependencies options could be adapted to refetch the wfs data when activated. They are made to refecth the data and refresh the

Re: [QGIS-Developer] WFS-T, postgis and triggers

2020-11-02 Thread Bo Victor Thomsen
Good idea - But make it an option for the specific layers, so it's possible to turn it "off" or "on" depending of the situation. And "off" should be the default. -- Med venlig hilsen / Kind regards Bo Victor Thomsen Den 02-11-2020 kl. 07:29 skrev Denis Rouzaud: But couldn't we just add an

Re: [QGIS-Developer] WFS-T, postgis and triggers

2020-11-01 Thread Denis Rouzaud
But couldn't we just add an option to the layer to re-fetch the data once inserted? Le dim. 1 nov. 2020 à 10:39, Carlo A. Bertelli (Charta s.r.l.) < carlo.berte...@gmail.com> a écrit : > I suppose we could benefit from the help of another Alessandro, the father > of Spatialite. I think he is

Re: [QGIS-Developer] WFS-T, postgis and triggers

2020-11-01 Thread Régis Haubourg
Hi, +1 with Denis, this is a quite common scenario, but the caching issue, combined with the good old WFS-T implementation spatialite provider issues looked like a big challenge. I think the future transactional version of WFS3 - OGC APIF should speed up and simplify a lot the protocol part. On

Re: [QGIS-Developer] WFS-T, postgis and triggers

2020-11-01 Thread Carlo A. Bertelli (Charta s.r.l.)
I suppose we could benefit from the help of another Alessandro, the father of Spatialite. I think he is already working on WFS3. Maybe this could lead to an enhancement of libspatialite to make XML/JSON sources a more interactive part of Spatialite itself or a virtualwms data provider for

Re: [QGIS-Developer] WFS-T, postgis and triggers

2020-10-29 Thread Denis Rouzaud
Le jeu. 29 oct. 2020 à 15:07, Alessandro Pasotti a écrit : > On Thu, Oct 29, 2020 at 2:59 PM Denis Rouzaud > wrote: > > > > Hi all, > > > > I have a WFS-T layer with a Postgis DB behind it. > > On my table, I have an insert trigger (before insert) which sets a field. > > When I create a feature

Re: [QGIS-Developer] WFS-T, postgis and triggers

2020-10-29 Thread Alessandro Pasotti
On Thu, Oct 29, 2020 at 2:59 PM Denis Rouzaud wrote: > > Hi all, > > I have a WFS-T layer with a Postgis DB behind it. > On my table, I have an insert trigger (before insert) which sets a field. > When I create a feature on this layer in QGIS, I don't get back the value of > this field (I have

[QGIS-Developer] WFS-T, postgis and triggers

2020-10-29 Thread Denis Rouzaud
Hi all, I have a WFS-T layer with a Postgis DB behind it. On my table, I have an insert trigger (before insert) which sets a field. When I create a feature on this layer in QGIS, I don't get back the value of this field (I have to refresh the data, by re-opening QGIS for instance). Is this