[GitHub] [superset] jonathanStrange0 commented on issue #15768: Postgresql DB Engine Error: '>=' not supported between instances of 'datetime.timedelta' and 'int'

[GitBox <gi...@apache.org>]

jonathanStrange0 commented on issue #15768:
URL: https://github.com/apache/superset/issues/15768#issuecomment-902577993


   I can replicate this issue using a fresh install of the latest docker image per the instructions [here](https://superset.apache.org/docs/installation/installing-superset-using-docker-compose). 
   
   Screenshot below.
   
   ![superset_issue_15768](https://user-images.githubusercontent.com/44637027/130059441-b59e7cfa-42d6-4304-9bba-8d2084a02415.png)
   
   According to a pip freeze in the app container (superset_app), this version is using psycopg2 v. 2.9.1.
   
   Manually replacing version 2.9.1 with 2.8.6 as suggested above resolves the issue.
   
   @mail2lawi's solution above (time at time zone 'CEST')... also was an effective fix, leading me to support the hypothesis that this issue is specifically related to columns which contain timestamptz values.
   
   Thank you for your help all!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org