openstreetmap/planetdump

Obsolete OpenStreetMap Planet Dump Generator - Replaced by https://github.com/zerebubuth/planet-dump-ng

planetdump's Issues

Edit repo description to make it clear this isn't used

This is old code and not used in production, and the description should be clear about that.

Weekly changeset dump incorrectly flagging all changesets as closed

Opened this in trac but was redirected here.

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 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' "