villebro commented on issue #5910: Can't make a timeserie if date is TIMESTAMP WITHOUT TIME ZONE (postgres) URL: https://github.com/apache/incubator-superset/issues/5910#issuecomment-423795940 Beyond the `psycopg2` problem, I'm not sure the current logic in `db_engine_specs` of adding `AT TIME ZONE 'UTC'` to all postgres time grains is working as intended. Based on the documentation https://www.postgresql.org/docs/9.2/static/functions-datetime.html (9.9.3), this notation changes timestamps with timezone into timestamps without timezone and vice versa. Furthermore, `AT TIME ZONE 'UTC'` is not added to the None time grain, which explains why one or the other always works. Perhaps they should all be cast to `::timestamp` or `::timestamptz` to ensure uniform type.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
