Re: tzdata 2025a and timestamptz.out - Mailing list pgsql-hackers

From Tom Lane
Subject Re: tzdata 2025a and timestamptz.out
Date
Msg-id 3081498.1737403740@sss.pgh.pa.us
Whole thread Raw
In response to tzdata 2025a and timestamptz.out  (Christoph Berg <cb@df7cb.de>)
List pgsql-hackers
Christoph Berg <cb@df7cb.de> writes:
>  SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC';
>           timezone
>  --------------------------
> - Wed Dec 09 15:56:00 1846
> + Wed Dec 09 15:56:08 1846

Grumble.  Let's switch to using Asia/Singapore in this test case.
It has a roughly similar UTC offset, and that offset hasn't
changed in tzdb since 2003.  (Gotta love "git blame".)

            regards, tom lane



pgsql-hackers by date:

Previous
From: Jim Jones
Date:
Subject: Re: XMLDocument (SQL/XML X030)
Next
From: Bruce Momjian
Date:
Subject: Re: Re: proposal: schema variables