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?
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 |