From: Brett Henderson [mailto:[email protected]] Sent: Friday, July 19, 2013 6:20 PM Subject: Re: [osmosis-dev] osmosis loading, apidb and time zones
> I'm not sure how to diagnose this one. Perhaps trace queries against the > database server and see what Osmosis is passing in? Probably easiest. I suspect postgres getting passed the wrong data. > I'm also not sure why the schema doesn't use "timestamp with time zone". > It should make things a lot easier and allow all components to do > automatic timezone conversion as necessary. I seem to recall having > similar issues on the main OSM servers. I can't remember what the final > fix was there, but usually I aim to have everything running in UTC to > avoid these issues. My understanding from #postgres is that you want to want to avoid one of with or without, I'm just not sure which. _______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
