public inbox for [email protected]
help / color / mirror / Atom feedFrom: Victor Wagner <[email protected]>
To: PostgreSQL Hackers <[email protected]>
Subject: Enderbury Island disappeared from timezone database
Date: Fri, 27 Oct 2023 15:20:49 +0300
Message-ID: <[email protected]> (raw)
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 <[email protected]>
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Enderbury Island disappeared from timezone database
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox