agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: ranjitsaurav <ranjitsaurav@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Exception Handling in Postgis function
Date: Thu, 12 Nov 2015 00:35:54 -0700 (MST)
Message-ID: <1447313754606-5873613.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Message-ID: <1447313754606-5873613.post@n5.nabble.com>
Permalink:  ../1447313754606-5873613.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1447313754606-5873613.post@n5.nabble.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ranjitsaurav@gmail.com
  Subject: Re: Exception Handling in Postgis function
  In-Reply-To: <1447313754606-5873613.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox