Horton

Re: tzdata 2025a and timestamptz.out

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christoph Berg <cb@df7cb.de>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-01-20T20:09:00Z
Lists: 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

Commits

  1. Avoid using timezone Asia/Manila in regression tests.