The following bug has been logged on the website:
Bug reference: 18455
Logged by: gowtham kumar
Email address: gkchinna.oracle@gmail.com
PostgreSQL version: 14.11
Operating system: Linux
Description:
Hi Team,
Appears that for the timezone "Europe/Dublin" the is_dst is flagged
wrongly.
From the IANA data I can see "Europe/Dublin" is following the DST
zdump -v /tmp/tzdb/zoneinfo/Europe/Dublin | grep -i '2024'
/tmp/tzdb/zoneinfo/Europe/Dublin Sun Mar 31 00:59:59 2024 UTC = Sun Mar 31
00:59:59 2024 GMT isdst=1
/tmp/tzdb/zoneinfo/Europe/Dublin Sun Mar 31 01:00:00 2024 UTC = Sun Mar 31
02:00:00 2024 IST isdst=0
/tmp/tzdb/zoneinfo/Europe/Dublin Sun Oct 27 00:59:59 2024 UTC = Sun Oct 27
01:59:59 2024 IST isdst=0
/tmp/tzdb/zoneinfo/Europe/Dublin Sun Oct 27 01:00:00 2024 UTC = Sun Oct 27
01:00:00 2024 GMT isdst=1
However, from the pg_timezone_names it is flagged to false though it is
actually following the DST
postgres=# select substr( version(), 1, 17);
substr
-------------------
PostgreSQL 14.11
(1 row)
postgres=# select * from pg_timezone_names where name ilike '%dublin%';
name | abbrev | utc_offset | is_dst
---------------+--------+------------+--------
Europe/Dublin | IST | 01:00:00 | f
(1 row)
utc_offset and abbrev is reflecting the correct data and the timestamp as
well is giving output as expected.
Is the information from the is_dst flag can be treated as bug?