[postgis-users] More details for errors

[Nicolas Ribot]

> 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???
>
>

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

Nicolas