From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Bernhard M. Wiedemann" <bwiedemann@suse.de>
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: jsonb_jsonpath test fails after 2024-11-03
In-reply-to: <ba8e1bc0-8a99-45b7-8397-3f2e94415e03@suse.de>
References: <ba8e1bc0-8a99-45b7-8397-3f2e94415e03@suse.de>
Comments: In-reply-to "Bernhard M. Wiedemann" <bwiedemann@suse.de>
	message dated "Wed, 30 Oct 2024 15:55:26 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <596788.1730301368.1@sss.pgh.pa.us>
Date: Wed, 30 Oct 2024 11:16:08 -0400
Message-ID: <596789.1730301368@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/596789.1730301368%40sss.pgh.pa.us>
Precedence: bulk

"Bernhard M. Wiedemann" <bwiedemann@suse.de> writes:
> While working on reproducible builds for openSUSE, I found that
> our postgresql17 package fails the jsonb_jsonpath test
> when building after 2024-11-03 (the US DST change).

Many thanks for the report!  This test case is indeed new since
the last DST change.  We would have found out about it anyway
when the buildfarm went red this coming Sunday :-(, but with a
release deadline coming up fast, several extra days' notice is
hugely valuable.

> Tests should be designed to continue working into the far future.

Sadly, anything to do with time zones is subject to the whims
of politicians, not to mention the IANA tzdb crew.  So there's
only so much we can do.

			regards, tom lane