Nico,
Also check that the spatial tables have a spatial index, an integer unique key
and run an ST_IsValid() check from Postgis on the geometries to ensure the data
is clean before opening in QGIS.
Brent Wood
________________________________
From: Luca Lanteri <mesca...@gmail.com>
To: Nico Alberti <n...@langhirano.it>
Cc: qgis-user <qgis-user@lists.osgeo.org>
Sent: Sunday, March 30, 2014 9:06 AM
Subject: Re: [Qgis-user] Qgis slow in retrieving PGsql data.
Which version of PostGIS are you using ?
You have to check to have at least select grants to the geometry_columns table
(in postgis 1.5) or view (in postgis 2.0) in public schema.
If you can't access to this table qgis spends a lot of time in order to scan
all geometries of all layer.
with PostGIS < 2.0 you also have to manually register you layer into the
geometry_columns table
regards
Luca
2014-03-28 13:38 GMT+01:00 Nico Alberti <n...@langhirano.it>:
Hi everybody. I am rather new to both technnologies (Qgis and PGsql data) so
sorry if the question is lame. When I try to connect to a PGsql database,
everything goes fine; layers are correctly listed and I can see their geometry
type and primary keys. However the "add layer" [1] is disabled: on the lower
left part of QGis there is a message saying that QGis is busy scanning the
"the_geom" column, and this is taking a lot of time (there are several huge
datasets in that db).
>
>After the scan is over, eventually I am not able to load most of the datasets.
>A message states they are invalid and cannot be loaded.
>
>I know I am not giving you a lot of hints. The errors are quite generic.
>However when I try to connect to another PGsql database (one that I can fully
>manage) everything goes fine. Could the dataset be corrupted in some strange
>way, could they lack something that forces QGis to scan the entire geometry
>data?
>
>Every suggestion would be greatly appreciated. Thank you in advance.
>
>[1] messages are in Italian, as you can guess. The actual English message is
>probably different.
>--
>Ciao
>Nico
>_______________________________________________
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/qgis-user
>
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user