[openstreetmap/openstreetmap-website] Switch to TIMESTAMP WITH TIME ZONE for current_* tables (#375)

Tom Hughes notifications at github.com
Wed Nov 21 11:15:27 UTC 2018


So it seems you're right which is very, err, counter-intuitive. My understanding had always been with a `with timezone` column stored an indication of the original timezone so that you could store values from different timezones and then recover the original zone.

Apparently that is not true for Postgres at least, and it always returns values in the servers default timezone.

My only remaining concern is that timestamp constants are always treated as `without timezone` unless explicitly cast which might cause an issue if somebody had a non-UTC default timezone?

-- 
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/openstreetmap-website/issues/375#issuecomment-440627673
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20181121/d1a1f00f/attachment.html>


More information about the rails-dev mailing list