You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jul 24, 2021. It is now read-only.
Reporter: ToeBee [Submitted to the original trac issue database at 12.44pm, Friday, 21st September 2012]
Not really a core map API problem but I don't see a more fitting component in trac.
All changesets in the weekly changeset dump file are marked as being closed even if they are still open at the time of the dump.
After talking about it in #osm-dev, TomH determined that it is because the now() function in the SQL on line 235 of [http://git.openstreetmap.org/planetdump.git/blob/HEAD:/planet06_pg.cpp#l235 planet06_pg.cpp] returns server local time whereas the closed_at column is stored in UTC. Since closed_at is set to one hour in the future every time a changeset is updated, that comparison will always return false.
A possible fix is to change "now()" to "now() at time zone 'utc' "
The text was updated successfully, but these errors were encountered:
Reporter: ToeBee
[Submitted to the original trac issue database at 12.44pm, Friday, 21st September 2012]
Not really a core map API problem but I don't see a more fitting component in trac.
All changesets in the weekly changeset dump file are marked as being closed even if they are still open at the time of the dump.
After talking about it in #osm-dev, TomH determined that it is because the now() function in the SQL on line 235 of [http://git.openstreetmap.org/planetdump.git/blob/HEAD:/planet06_pg.cpp#l235 planet06_pg.cpp] returns server local time whereas the closed_at column is stored in UTC. Since closed_at is set to one hour in the future every time a changeset is updated, that comparison will always return false.
A possible fix is to change "now()" to "now() at time zone 'utc' "
The text was updated successfully, but these errors were encountered: