> 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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users