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
Date: Wed, 30 Oct 2024 11:16:08 -0400
Message-ID: <596789.1730301368@sss.pgh.pa.us> (raw)
In-Reply-To: <ba8e1bc0-8a99-45b7-8397-3f2e94415e03@suse.de>
References: <ba8e1bc0-8a99-45b7-8397-3f2e94415e03@suse.de>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, bwiedemann@suse.de, pgsql-bugs@lists.postgresql.org
Subject: Re: jsonb_jsonpath test fails after 2024-11-03
In-Reply-To: <596789.1730301368@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox