[postgis-users] How to index GeometryCollections

Andreas Kalsch andreaskalsch at gmx.de
Thu Oct 1 12:36:30 PDT 2009


The query

"SELECT class, id FROM geoobject_geom
WHERE ST_Intersects(
    GeomFromText(?, 4326),
    geom
)
LIMIT 1000"

results in exception

"SQLSTATE[XX000]: Internal error: 7 ERROR:  Relate Operation called with
a LWGEOMCOLLECTION type.  This is unsupported"

1) When will the relation check functions support GeometryCollections as
arguments? This is even supported in MySQL ;)
2) Is the only way to index GeometryCollections to index many single
geometries?

Thanks,

Andi




More information about the postgis-users mailing list