Re: jsonb_jsonpath test fails after 2024-11-03

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bernhard M(dot) Wiedemann" <bwiedemann(at)suse(dot)de>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: jsonb_jsonpath test fails after 2024-11-03
Date: 2024-10-30 15:16:08
Message-ID: 596789.1730301368@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Bernhard M. Wiedemann" <bwiedemann(at)suse(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2024-10-30 19:57:53 BUG #18678: While installing the PostgreSQL wizard, it throws an error for an non found column
Previous Message Bernhard M. Wiedemann 2024-10-30 14:55:26 jsonb_jsonpath test fails after 2024-11-03