[postgis-users] Help with spatial query (bug??)

[Brent Wood]

--- Markus Schaber <schabi at logix-tt.com> wrote:
> Hi, Brent,

Hi...

> By default, PostGIS does not do validity checks on data insertion,
> because this is a relatively expensive operation on complex geometries,
> but you cannot rely on anything if you insert geometries that are not valid.
> 
> You can add this check at data insertion time by using a statement like
> the following:
> 
> ALTER TABLE mytable ADD CONSTRAINT geometry_valid_check CHECK
> (isvalid(the_geom));


Thanks Markus, that does tidy things up for me.

Who is writing the definitive "Book of PostGIS" with all this info?
(you have one buyer waiting :-)


Brent