Re: jsonb_jsonpath test fails after 2024-11-03

"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