[postgis-users] Intersects with empty boxes error

Markus Schaber schabios at logi-track.com
Tue Jan 25 09:36:08 PST 2005

Hi, Daniel,

Daniel FAIVRE schrieb:
> Ok, thank you, but:
> 1) It worked on previous versions.

Well - most fixed bugs describe a behaviour that "worked on previous
versions", but was never intended to work this way.

> 2) geometryfromtext('BOX3D(10 10, 10 10)', -1) does NOT fail to create a
> geometry, even if the box collapses to a point. Should it allow creating
> "geos unvalid geometries" ?

The problem is that geos validity check is very expensive on complicated
geometrys (polygons with hundreds of thousands of vertices). Enforcing
those checks on every geometry input (that is supposed to get no invalid
geometries) would slow down the whole thing.

If you need it, you can use isvalid(geometry), and even add an
appropriate check constraint to your tables to allow storage of valid


markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios at logi-track.com | www.logi-track.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 256 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050125/02338906/attachment.pgp>

More information about the postgis-users mailing list