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

[Denis Rouzaud]

Le jeu. 29 oct. 2020 à 15:07, Alessandro Pasotti <apasotti at gmail.com> a
écrit :

> On Thu, Oct 29, 2020 at 2:59 PM Denis Rouzaud <denis.rouzaud at gmail.com>
> 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 to refresh the data, by re-opening QGIS for
> instance).
> >
> > Is this expected?
>
> Yes. The features are locally cached in a SQLite layer and a newly
> created feature will be stored locally and not retrieve from the
> server.
>
> > Is there anything we can fix?
>
> Of course yes but it would require re-fetching the feature(s) after an
> insert or an update, I think it will slow things down.
>

This could be done asynchronously?
It sounds like a quite common scenario (or not if nobody complained...).

Thanks for the answer anyway.


> Besides that there is no perfect solution to server-side changes: if
> some other user will trigger a data change on the DB we will of course
> miss it anyway.
>
>
> > Am I doing something wrong?
>
> No.
>
> Cheers
>
>
> --
> Alessandro Pasotti
> QCooperative:  www.qcooperative.net
> ItOpen:   www.itopen.it
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20201029/e59c215b/attachment.html>