[postgis-users] Description of invalidity ?

strk at refractions.net strk at refractions.net
Fri Mar 17 06:20:50 PST 2006

A possible way to handle this would be defining another
function, returning an invalidity message rather then
a boolean value, and NULL in case of a valid geom.

With current functions set you can only grab
the NOTICE channel and figure out yourself when
they belong to isvalid() run.


On Fri, Mar 17, 2006 at 03:15:23PM +0100, Arnaud Lesauvage wrote:
> Hi List !
> I want to check geometries for validity. When I run my query
> (SELECT * FROM MyTable WHERE IsValid(myGeometry)=False) in
> pgAdmin, I have some messages (in the message window) that explain
> the reason why the geometry is not valid.
> Can I easily retrieve these messages ?
> This query is meant to be run through psqlODBC in a VBA macro, and
> I would like to give the user the reason why his geometry was
> rejected.
> How could I accomplish this ?
> Thanks for your help !
> Regards
> --
> Arnaud

More information about the postgis-users mailing list