[postgis-users] Inefficient query with QGIS?

[George Silva]

I don't know the inner functioning of QGIS, but perhaps it should scan
geometry_columns first and only then try to figure out the geometry?

George

----- 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
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
George R. C. Silva

Desenvolvimento em GIS
http://blog.geoprocessamento.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110130/80f831ca/attachment.html>