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@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@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
