[postgis-users] Inefficient query with QGIS?

[Nicklas Avén]

Hallo

I have no answer to your question but I know that QGIS doesn't require a representation in geometry columns table. 

/nicklas

----- Original message -----
> I noticed this really inefficient query when QGIS was importing a Postgis
> layer:
> *select distinct case when geometrytype("the_geom") IN
> ('POINT','MULTIPOINT') THEN 'POINT' when geometrytype("the_geom") IN
> ('LINESTRING','MULTILINESTRING') THEN 'LINESTRING' when
> geometrytype("the_geom") IN ('POLYGON','MULTIPOLYGON') THEN 'POLYGON' end
> from [databaseGoesHere]*
> 
> That surprised me because QGIS should already know the *geometrytype
> *through the *geomerty_columns* table.
> 
> Is this really QGIS's fault, or did Postgis cause/require this? Want to
> make sure before I file a bug report.
> 
> Thanks,
> 
> Aren

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110130/78a2576a/attachment.html>