Thread: Exception Handling in Postgis function
Hi I am new in the postgressql. I am trying to using the exception handling for the postgis function. The query is as follows. "SELECT topology.AddEdge('road_topology', ST_GeomFromText(l.linestring, 4326)) As edgeid from (SELECT ST_AsText(geom) as linestring FROM public.clip_linestring) as l;" This query is showing error as follows ERROR: Edge intersects (not on endpoints) with existing edge 162 at or near point POINT(100.3812061 13.6915724) I would like to implement exception handling so that I could know from which line of table "clip_linestring" this error is coming. How do I use the exception handling for these kind of issue. Thank you. Regards, Saurav Ranjit -- View this message in context: http://postgresql.nabble.com/Exception-Handling-in-Postgis-function-tp5873613.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com.