Re: jsonb_jsonpath test fails after 2024-11-03 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: jsonb_jsonpath test fails after 2024-11-03
Date
Msg-id 596789.1730301368@sss.pgh.pa.us
Whole thread Raw
List pgsql-bugs
"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



pgsql-bugs by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: BUG #18675: Postgres is not realasing memory causing OOM
Next
From: PG Bug reporting form
Date:
Subject: BUG #18678: While installing the PostgreSQL wizard, it throws an error for an non found column