Horton

Re: Regression tests fail with tzdata 2024b

Wolfgang Walther <walther@technowledgy.de>

View thread
From: Wolfgang Walther <walther@technowledgy.de>
To: Tom Lane <tgl@sss.pgh.pa.us>, Sven Klemm <sven@timescale.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2024-09-17T06:39:53Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Run regression tests with timezone America/Los_Angeles.

  2. Don't require bleeding-edge timezone data in timestamptz regression test.

Tom Lane:
>> I was wondering whether the timezone used by pg_regress could be made
>> configurable.
> 
> Yes, I understood that you were suggesting that.  My point is that
> it wouldn't do you any good: you will still have to change any
> regression test cases that depend on behavior PST8PDT has/had that
> is different from America/Los_Angeles.  That being the case,
> I don't see much value in making it configurable.

Just changing it back to PST8PDT wouldn't really help as Tom pointed 
out. You'd still get different results depending on which tzdata version 
you are running with.

The core regression tests need to be run with a timezone that tests 
special cases in the timezone handling code. But that might not be true 
for extensions - all they want could be a stable output across major and 
minor versions of postgres and versions of tzdata. It could be helpful 
to set pg_regress' timezone to UTC, for example?

Best,

Wolfgang