[Qgis-user] QGIS-Server How to avoid unique data check in postgis for each session

[Amedeo Fadini]

Thank-you very much Jurgen, it works.
I found that in the .qgs file it an attribute "estimatedmetadata=true" on
ayer-tree-layer and datsource element.
Wonder if checkPrimaryKeyUnicity='1' on the same elements does mean
anything...

Amedeo

Il giorno mer 16 nov 2022 alle ore 15:00 Jürgen E. Fischer via Qgis-user <
qgis-user at lists.osgeo.org> ha scritto:

> Hi Amedeo,
>
> On Wed, 16. Nov 2022 at 14:18:57 +0100, Amedeo Fadini via Qgis-user wrote:
> > SELECT count(distinct ("id","field1"))=count(("id","field1")) FROM
> > "public"."mytable"
>
> Check  "use estimated table metadata" in the connection before adding the
> layer.
>
>
> Jürgen
>
>
> --
> Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
> Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
> Software Engineer           D-26506 Norden
> https://www.norbit.de
> QGIS release manager (PSC)  Germany                 IRC: jef on Libera|OFTC
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20221116/242a1a31/attachment.htm>