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