Date: Fri, 27 Oct 2023 15:20:49 +0300
From: Victor Wagner <vitus@wagner.pp.ru>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Enderbury Island disappeared from timezone database
Message-ID: <20231027152049.4b5c8044@wagner.wagner.home>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/20231027152049.4b5c8044%40wagner.wagner.home>
Precedence: bulk

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@wagner.pp.ru>