Обсуждение: tzdata 2025a and timestamptz.out

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

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