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
>> [email protected]
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
--
George R. C. Silva
Desenvolvimento em GIS
http://blog.geoprocessamento.net
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
