[postgis-users] how to identify the_geom that cause : Relate Operation called withLWGEOMCOLLECTION type

[Nicolas Ribot]

> I have an error with some geometry that cause : "ERROR Relate Operation
> called withLWGEOMCOLLECTION type".
> All the geometries seem clean (valid, non empty, closed, only POLYGON,  ..)
> My question : how to get information of which geometry cause the problem ?
> Is there a way  to have information about the geometry during postgis is
> working on a  SQL query ?
> Thanks.
>

Hi Ghislain,

What the query that failed looks like ?
The message is telling that one geometry has an invalid type.
In your query, you could try to ask for ST_GeometryType(geometry) and
a geometry identifier to see which geometry has the wrong type.
If you perform a spatial operation, it is possible that
geometryCollection is produced.
You could maybe split your query into smaller block to see where such
collections are generated.

Nicolas