[OSM-dev] invalid geometry in planet_polygon

[Stefan de Konink]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Op 24-08-10 17:25, nimix schreef:
>> It is really a bitch that PostgreSQL cannot use the ST_IsValid as index
>> in queries. Yes, you could manually do the boolean operation yourself,
>> but still it would be quite handy if the validness wouldn't be checked
>> at all if it was valid in the first place.
> 
> Why not? I think an index like [1] should work and speed up your queries as
> the validity is only checked once on insert or on the build operation.
> regards,
> Melchior
> 
> [1]
> CREATE INDEX idx_planet_osm_polygon_valid ON planet_osm_polygon USING btree
> (ST_IsValid(way));

The index is never used... and how do I know? Because I actually tried it...


Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEAREKAAYFAkxz6BEACgkQYH1+F2Rqwn1zMwCcC26BVrL9Ol5tQSWI1kjZOe5Z
zsEAnR/QiZOsWTLdm9OApngAqaZXUjFn
=sfSo
-----END PGP SIGNATURE-----