[Tile-serving] [osm2pgsql] Use GeoHash ordering instead of way ordering (b2a9f72)

[it-solutions-zehaczek]

Hi,

i just tried an import using 0.87.2-dev on postgres 9.1 with enabled slim-mode, hstore and flatnodes and got the following error:
CREATE TABLE planet_osm_polygon_tmp  AS SELECT * FROM planet_osm_polygon ORDER BY ST_GeoHash(ST_Transform(ST_Envelope(way),4326),10) failed: ERROR:  ST_GeoHash: lwgeom_geohash returned NULL.

A switchback to 0.87.1 solves the problem.

It seems to depend on the data. Planet, Germany and Hesse crashed. Some other smaller areas passed without error. So you best test with Hesse file if you like to reproduce the error (http://download.geofabrik.de/europe/germany/hessen.html).

Regards,
Chris

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/commit/b2a9f7280e13d67aa287ca4202356ff1073338f2#commitcomment-9441314
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20150126/e3e29611/attachment.html>