Postgres Pro
Downloads
Home   >   mailing lists

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 CAD5tBcLNF7vq8PnCOS11kqxueXhXd7+3SvwtjPPc2zKZ2hQ3TQ@mail.gmail.com
Whole thread Raw
In response to 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
Tree view



On Tue, Oct 29, 2024 at 11:50 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Update time zone data files to tzdata release 2024b.

Historical corrections for Mexico, Mongolia, and Portugal.
Notably, Asia/Choibalsan is now an alias for Asia/Ulaanbaatar
rather than being a separate zone, mainly because the differences
between those zones were found to be based on untrustworthy data.

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/502e7bf7f09c458ce66ce043b94864b535c5d5d0

Modified Files
--------------
src/timezone/data/tzdata.zi     | 1653 +++++++++++++++++++--------------------
src/timezone/known_abbrevs.txt  |    2 -
src/timezone/tznames/Default    |    6 +-
src/timezone/tznames/Europe.txt |    6 +-
4 files changed, 824 insertions(+), 843 deletions(-)



Crake doesn't seem to like this for cross version upgrade, and the diff looks rather odd:


 
--- /home/andrew/bf/root/upgrade.crake/HEAD/origin-REL9_2_STABLE.sql.fixed	2024-10-29 13:40:01.778445456 -0400
+++ /home/andrew/bf/root/upgrade.crake/HEAD/converted-REL9_2_STABLE-to-HEAD.sql.fixed	2024-10-29 13:40:01.780445460 -0400
@@ -206462,12 +206462,12 @@ 1997-02-14 20:32:01-05 1997-02-15 20:32:01-05 1997-02-16 20:32:01-05
-0097-02-16 20:32:01-05 BC
-0097-02-16 20:32:01-05
-0597-02-16 20:32:01-05
-1097-02-16 20:32:01-05
-1697-02-16 20:32:01-05
-1797-02-16 20:32:01-05
+0097-02-16 20:35:59-04:56:02 BC
+0097-02-16 20:35:59-04:56:02
+0597-02-16 20:35:59-04:56:02
+1097-02-16 20:35:59-04:56:02
+1697-02-16 20:35:59-04:56:02
+1797-02-16 20:35:59-04:56:02 1897-02-16 20:32:01-05 1997-02-16 20:32:01-05 2097-02-16 20:32:01-05


cheers

andrew

pgsql-committers by date:

Previous
From: Jeff Davis
Date:
Subject: pgsql: Add missing CommandCounterIncrement() in stats import functions.
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Update time zone data files to tzdata release 2024b.