From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wolfgang Walther <walther@technowledgy.de>
cc: Sven Klemm <sven@timescale.com>, pgsql-hackers@lists.postgresql.org
Subject: Re: Regression tests fail with tzdata 2024b
In-reply-to: <d51522f0-c122-4dda-b787-62c376895fdc@technowledgy.de>
References: <0a997455-5aba-4cf2-a354-d26d8bcbfae6@technowledgy.de> <441306.1726346239@sss.pgh.pa.us> <38e73fef-f19b-4835-b353-a110db6c8318@technowledgy.de> <1043017.1726463364@sss.pgh.pa.us> <CAMCrgp1W7DWBNA4GQCKBPyUS7nV15j_8kedkBWX2ud6w1n06Yw@mail.gmail.com> <1156795.1726499982@sss.pgh.pa.us> <CAMCrgp3vqoUKgLk2nshO-po-s26gEPWXT0wxjOkbrNqQ6TwAaA@mail.gmail.com> <1399310.1726551755@sss.pgh.pa.us> <d51522f0-c122-4dda-b787-62c376895fdc@technowledgy.de>
Comments: In-reply-to Wolfgang Walther <walther@technowledgy.de>
	message dated "Tue, 17 Sep 2024 08:39:53 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1462676.1726582525.1@sss.pgh.pa.us>
Date: Tue, 17 Sep 2024 10:15:25 -0400
Message-ID: <1462677.1726582525@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1462677.1726582525%40sss.pgh.pa.us>
Precedence: bulk

Wolfgang Walther <walther@technowledgy.de> writes:
> 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?

I would not recommend that choice.  It would mask simple errors such
as failing to apply the correct conversion between timestamptz and
timestamp values.  Also, if you have test cases that are affected by
this issue at all, you probably have a need/desire to test things like
DST transitions.

			regards, tom lane