[Tile-serving] [osm2pgsql] Deleted objects and *.osc file (#127)
Paul Norman
notifications at github.com
Mon Apr 7 19:38:23 UTC 2014
Just a few initial thoughts, without having stepped through the ``--expire-tiles`` code.
So, to fix this, we obviously need to return geometries as we ``DELETE`` them from the database.
I think will mean changing
```sql
DELETE
FROM planet_osm_point
WHERE osm_id = ANY(ARRAY[...])
```
to
```sql
DELETE
FROM planet_osm_point
WHERE osm_id = ANY(ARRAY[...])
RETURNING way
```
I'm not sure what the performance impact of this would be.
Alternatively, we might be dealing with a node **not** in planet_osm_point, but then it shouldn't cause any rendering changes by itself.
---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/127#issuecomment-39773851
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20140407/8b2d0bf3/attachment.html>
More information about the Tile-serving
mailing list