[Tile-serving] [openstreetmap/osm2pgsql] Import of changes failing because of TopologyException (#787)

[Paul Norman]

Taking a look at this. Just to note, to trigger it on updates I'm doing a normal `--create --slim` and then

``psql -d gis -c 'TRUNCATE planet_osm_polygon;TRUNCATE planet_osm_nodes;TRUNCATE planet_osm_rels;TRUNCATE planet_osm_ways;' && ./osm2pgsql -d gis ../r2823696.osm -S ../default.style --slim --append && psql -X -d gis -c 'select count(*) from planet_osm_polygon where not st_isvalid(way);'``

I'm looking at updates first because initial import is easy - just add a `WHERE` to the ``CREATE TABLE ... AS SELECT ... ORDER BY ...`` as @lonvia noted. Because we sort everything in the rendering tables and gazetteer is 4326, we don't need to consider unsorted tables.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/787#issuecomment-333256800
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170929/a7aee142/attachment.html>