Thank you Brent and Luca. Today I could check that PostGis db again, and I discovered that actually many layers lack spatial indexes or even unique keys. Should have checked QGis logs more thoroughly :-) as the issue is clearly shown there. As a matter of fact I did not even know QGis has a log...
And for the original question I found that i can get rid of the "busy" message box if I check the "do not resolve urestricted geometry types" in the postgis connection parameters dialog (or something like that. As I said in the OP I am using the Italian interface. Thank you again. Ciao Nico 2014-03-29 23:38 GMT+01:00 Brent Wood <pcr...@pcreso.com>: > 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