[Tile-serving] [osm2pgsql] modified relation removes existing way and adds it again (#559)

[Paul Norman]

This seems to be expected behavior.

The change to a relation forces it to be pending, so it's either going to be deleted or updated, and updating consists of a delete and insert. The insert just happens to be the same data because the changes didn't result in any changes to the output columns.

> Edit: Maybe "clustering" (ordering by GeoHash) is the problem, which makes the trigger think the row gets deleted?

No, it's only relevant for initial table order.

---
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/559#issuecomment-197498764
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20160316/2c7131b6/attachment-0001.html>