Re: Regression tests fail with tzdata 2024b

From: Wolfgang Walther <walther(at)technowledgy(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Regression tests fail with tzdata 2024b
Date: 2024-09-15 09:08:11
Message-ID: 38e73fef-f19b-4835-b353-a110db6c8318@technowledgy.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane:
> Also, as a real place to a greater extent
> than "PST8PDT" is, it's more subject to historical revisionism when
> somebody turns up evidence of local law having been different than
> TZDB currently thinks.

I now tried all versions of tzdata which we had in tree back to 2018g,
they all work fine with the same regression test output. 2018g was an
arbitrary cutoff, I just didn't try any further.

In the end, we don't need a default timezone that will never change. We
just need one that didn't change in a reasonable number of releases
going backwards. Once America/Los_Angeles is changed, we need to switch
to a different zone, which could be one that wouldn't work today. Kind
of a sliding window.

One positive might be: With this timezone, we are more likely to see
relevant changes mentioned in the upstream release notes.

Best,

Wolfgang

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shawn wang 2024-09-15 17:48:44 Re: Trim the heap free memory
Previous Message Julien Rouhaud 2024-09-15 02:30:02 Re: Obsolete comment in pg_stat_statements