[OSM-dev] invalid geometry in planet_polygon

nimix melchiormoos at gmail.com
Tue Aug 24 16:25:48 BST 2010

Stefan de Konink-3 wrote:
> 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.

CREATE INDEX idx_planet_osm_polygon_valid ON planet_osm_polygon USING btree

View this message in context: http://gis.638310.n2.nabble.com/invalid-geometry-in-planet-polygon-tp5454655p5457332.html
Sent from the Developer Discussion mailing list archive at Nabble.com.

More information about the dev mailing list