[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!



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



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