[postgis-users] handling invalid geometry within a trigger

LPlateAndy andy at centremaps.co.uk
Mon Feb 15 07:17:04 PST 2016


Thanks Nicolas, that's really helpful i can see lots of instances my code
will now be more robust!

Andy


Hi,

In plpgsql, you can catch the error that will be generated by such a
polygon:

http://www.postgresql.org/docs/9.5/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

Nicolas

On 15 February 2016 at 15:43, LPlateAndy <andy at .co> wrote:

> Hi,
>
> I have a postgresql trigger function which creates a geometry from WKT
> before data in inserted into the table. Saves on temp tables or on loading
> and then updating.
>
> Is there a way (possibly a plpgsql not postgis question) to ignore (treat
> as
> NULL) a bum geometry - e.g a polygon with a single point
>
> Andy




--
View this message in context: http://postgis.17.x6.nabble.com/handling-invalid-geometry-within-a-trigger-tp5009691p5009693.html
Sent from the PostGIS - User mailing list archive at Nabble.com.


More information about the postgis-users mailing list