[Tile-serving] [openstreetmap/osm2pgsql] Timestamp of last change of object in database (#923)

tb notifications at github.com
Thu Sep 12 13:33:01 UTC 2019


> @mmd-osm you're right, timestamp is indeed provided in extracts.
> This should cover 99% of use cases.

You need to be careful about osm_timestamp. In the case of updating the database changing the coordinates of a point used by a polygon, the osm_timestamp of the polygon will not be changed, but the geometry in the <prefix>_polygon table will be.

But - if i get the request right - this can easily be achieved by a before-insert-trigger in the database, i'd suggest to spare this out in osm2pgsql anyway.


-- 
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/923#issuecomment-530827907
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20190912/96bda4f1/attachment.html>


More information about the Tile-serving mailing list