db_tz_support in date_api_sql.inc

Query is:
'2008-02-15 12:00:00 UTC' AT TIME ZONE 'US/Central'
Should be:
SELECT TIMESTAMP WITH TIME ZONE '2008-02-15 12:00:00 UTC' AT TIME ZONE 'US/Central'

Patch attached.

CommentFileSizeAuthor
0001-Fix-Postgresql-time-zone-support-query.patch642 byteshalcyonCorsair

Comments

karens’s picture

karens commented

See #279051: pgsql named time zone detection is incorrect. If that's wrong, you guys need to duke it out and tell me what works.

karens’s picture

karens commented
Status: Active » Postponed (maintainer needs more info)
halcyonCorsair’s picture

halcyonCorsair commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)

If you committed the fix as mentioned in the other bug it should do what I want.