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.
[ Full content available at: https://github.com/apache/incubator-superset/issues/5910 ] This message was relayed via gitbox.apache.org for [email protected]
