[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Exception Handling in Postgis function
From:       Sandro Santilli <strk () keybit ! net>
Date:       2015-11-16 7:52:44
Message-ID: 20151116075244.GC4884 () localhost
[Download RAW message or body]

On Fri, Nov 13, 2015 at 06:17:56PM -0800, ranjitsaurav wrote:

> 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. I would like to know
> the row in the table from which the error is being generated.
> 
> How do I use the exception handling for these kind of issue.

In plpgsql you'd use a block like this:

  BEGIN
    SELECT possiblyThrowingFunction();
  EXCEPTION
    WHEN OTHERS THEN
      msg := SQLERRM;
  END

--strk;
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]