BUG #18455: DST information is flagged wrongly
От | PG Bug reporting form |
---|---|
Тема | BUG #18455: DST information is flagged wrongly |
Дата | |
Msg-id | 18455-1f7c5337666bbd1a@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #18455: DST information is flagged wrongly
|
Список | pgsql-bugs |
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?
В списке pgsql-bugs по дате отправления: