Exception Handling in Postgis function - Mailing list pgsql-sql

From ranjitsaurav
Subject Exception Handling in Postgis function
Date
Msg-id 1447313754606-5873613.post@n5.nabble.com
Whole thread Raw
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: query option in COPY postgres
Next
From: "david.paulo"
Date:
Subject: Re: How would I get rid of trailing blank line?