Re: pgsql: Update time zone data files to tzdata release 2024b. - Mailing list pgsql-committers

From Andrew Dunstan
Subject Re: pgsql: Update time zone data files to tzdata release 2024b.
Date
Msg-id 55A5E01C-1B0F-40F9-94EA-FEDED1575C92@dunslane.net
Whole thread Raw
In response to Re: pgsql: Update time zone data files to tzdata release 2024b.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql: Update time zone data files to tzdata release 2024b.
List pgsql-committers


> On Oct 29, 2024, at 5:41 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Andrew Dunstan <andrew@dunslane.net> writes:
>> Crake doesn't seem to like this for cross version upgrade, and the diff
>> looks rather odd:
>
> Oh, that's annoying.  I forgot to mention the side-effects that 2024b
> had on PST8PDT and other SysV-derived timezones (probably because Paul
> Eggert avoided mentioning that in his release notes ... thanks for
> nothing Paul).  What we've got there is that sufficiently old
> timestamps (pre 1890 or so) are now interpreted as local mean solar
> time for Los Angeles rather than exactly UTC-8.
>
> I would expect that the upgrade tests would pass now for upgrades
> from v12 or later, thanks to b8ea0f675 et al, but I'm not real
> sure what to do about testing the out-of-support branches.  Should
> we back-patch b8ea0f675 as far down as 9.2?
>
>

Or fix/remove the problem rows in AdjustUpgrade.pm I guess

Cheers

Andrew


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Update time zone data files to tzdata release 2024b.
Next
From: Amit Kapila
Date:
Subject: pgsql: Replicate generated columns when specified in the column list.