Enderbury Island disappeared from timezone database
Victor Wagner <vitus@wagner.pp.ru>
From: Victor Wagner <vitus@wagner.pp.ru>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-10-27T12:20:49Z
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@wagner.pp.ru>
Commits
-
Remove PHOT from our default timezone abbreviations list.
- 64fc5e005421 11.22 landed
- 7180bb827bf5 12.17 landed
- d946128734b6 13.13 landed
- 877e7b4b9c99 14.10 landed
- 85b98a70bbea 15.5 landed
- d1537afe3e6e 16.1 landed
- 5fd3e06f6ad1 17.0 landed