Re: pgsql: Update time zone data files to tzdata release 2024b.

On Tue, Oct 29, 2024 at 11:50 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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