[Tile-serving] [openstreetmap/osm2pgsql] Update example config to appropriate timestamp types (Issue #1785)

mmd notifications at github.com
Fri Sep 30 09:38:57 UTC 2022


FYI: We had a fairly lengthy discussion on the topic a few years back: https://github.com/openstreetmap/openstreetmap-website/issues/375

tl;dr: as soon as your local machine is not running on utc+0, reading from timestamptz columns always needs an additional `at time zone 'UTC'`, or timestamps would be converted to your local tz (which tends to be a bit annoying when working with osm data).



-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1785#issuecomment-1263345462
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/issues/1785/1263345462 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220930/ee71dc85/attachment.htm>


More information about the Tile-serving mailing list