Thread

Commits

Avoid using timezone Asia/Manila in regression tests.
- dee1e86d0e6d 13.19 landed
- b7bad919e1b0 17.3 landed
- aac0384975ff 14.16 landed
- 8856267284a3 15.11 landed
- 8108674f0e56 18.0 landed
- 5054b7e10716 16.7 landed

tzdata 2025a and timestamptz.out

Christoph Berg <cb@df7cb.de> — 2025-01-20T19:23:10Z

It happened again:

News for the tz database

Release 2025a - 2025-01-15 10:47:24 -0800

  Briefly:
    ...
    Improve pre-1991 data for the Philippines.

 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

Christoph

Re: tzdata 2025a and timestamptz.out

Tom Lane <tgl@sss.pgh.pa.us> — 2025-01-20T20:09:00Z

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