PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16123
PG Version11.5
OSMacOS (Mojave)
Opened2019-11-18 05:37:53+00
Reported byThushara Wijeratna
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16123
Logged by:          Thushara Wijeratna
Email address:      (redacted)
PostgreSQL version: 11.5
Operating system:   MacOS (Mojave)
Description:        

maestro_development=# select timestamp with time zone '2019-12-01T02:00:00Z'
at time zone 'America/Sao_Paulo';
      timezone
---------------------
 2019-11-30 23:00:00
(1 row)

From Nov 3, America/Sao_Paulo should be offset only 2 hours from UTC due to
DTS. I would expect the timestamp to be December 1st midnight.

https://www.travelmath.com/time-zone/America/Sao_Paulo

Messages

DateAuthorSubject
2019-11-18 05:37:53+00PG Bug reporting formBUG #16123: DST not respected for America/Sao_Paulo in `timestamp` function
2019-11-18 06:51:29+00Thomas MunroRe: BUG #16123: DST not respected for America/Sao_Paulo in `timestamp` function
2019-11-18 14:41:51+00Tom LaneRe: BUG #16123: DST not respected for America/Sao_Paulo in `timestamp` function
2019-11-18 19:52:15+00Thushara WijeratnaRe: BUG #16123: DST not respected for America/Sao_Paulo in `timestamp` function