BUG #18455: DST information is flagged wrongly

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: gkchinna(dot)oracle(at)gmail(dot)com
Subject: BUG #18455: DST information is flagged wrongly
Date: 2024-05-02 12:21:24
Message-ID: 18455-1f7c5337666bbd1a@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18455
Logged by: gowtham kumar
Email address: gkchinna(dot)oracle(at)gmail(dot)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?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2024-05-02 15:08:23 Re: BUG #18455: DST information is flagged wrongly
Previous Message PG Bug reporting form 2024-05-02 11:57:05 BUG #18454: Reproducible SIGSEGV in query