From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: gkchinna.oracle@gmail.com
Subject: BUG #18455: DST information is flagged wrongly
Date: Thu, 02 May 2024 12:21:24 +0000
Message-ID: <18455-1f7c5337666bbd1a@postgresql.org> (raw)
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?
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: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, gkchinna.oracle@gmail.com
Subject: Re: BUG #18455: DST information is flagged wrongly
In-Reply-To: <18455-1f7c5337666bbd1a@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox