[postgis-users] More details for errors

Nicolas Ribot nicolas.ribot at gmail.com
Mon Mar 26 05:00:40 PDT 2012

> Hi all,
> I have a view which does this
> ST_LineMerge(ST_Union(wkb_geometry))::geometry(LineString,21781)
> In case of the lines are not juxtaposed, I have this error
> ERROR:  Geometry type (MultiLineString) does not match column type
> (LineString)
> Is there a way of getting the line ID which leads to the error???

you could execute the SQL query defining the view and filter features
where geometryType(wkb_geometry) = 'LINESTRING' to identify only
problematic features.


More information about the postgis-users mailing list