[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