Enderbury Island disappeared from timezone database

From: Victor Wagner <vitus(at)wagner(dot)pp(dot)ru>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Enderbury Island disappeared from timezone database
Date: 2023-10-27 12:20:49
Message-ID: 20231027152049.4b5c8044@wagner.wagner.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Collegues,

I've encountered following problem compiling PostgreSQL 15.4 with just
released Ubuntu 23.10.

I'm compiling postgres with --with-system-tzdata and then regression
test sysviews fails with following diff:

--- /home/test/pg-tests/postgresql-15.4/src/test/regress/expected/sysviews.out 2023-10-26 19:06:02.000000000 +0000
+++ /home/test/pg-tests/postgresql-15.4/src/test/regress/results/sysviews.out 2023-10-27 07:10:22.214698986 +0000
@@ -147,23 +147,14 @@
(1 row)

select count(distinct utc_offset) >= 24 as ok from pg_timezone_abbrevs;
- ok
-----
- t
-(1 row)
-
+ERROR: time zone "Pacific/Enderbury" not recognized
+DETAIL: This time zone name appears in the configuration file for time zone abbreviation "phot".

with more such errors follows.

Investigation shows, that this timezone was long ago declared
deprecated, and eventually disappeared from tzdata package in Ubuntu
even as symlink to Pasific/Kanton (which is equivalent).

But this timezone present in src/timezone/tznames/Default, so this
error message is appears any time one access pg_timezone_abbrevs
regardless of Pacific region is included in results or not.

May be, Enderbury should be replaced by Kanton in
src/timezone/tznames/Default and src/timezone/tznames/Pacific.txt?

--
Victor Wagner <vitus(at)wagner(dot)pp(dot)ru>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message torikoshia 2023-10-27 12:30:02 Re: RFC: Logging plan of the running query
Previous Message Kirill Reshke 2023-10-27 12:19:27 Annoying corruption in PostgreSQL.