BUG #10112: Timezone abbrevs and it history
От | eshkinkot@gmail.com |
---|---|
Тема | BUG #10112: Timezone abbrevs and it history |
Дата | |
Msg-id | 20140423001535.2714.89878@wrigleys.postgresql.org обсуждение исходный текст |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 10112 Logged by: Sergey Burladyan Email address: eshkinkot@gmail.com PostgreSQL version: 9.3.4 Operating system: Debian testing Description: May be this is correct today, because there is no DST in Russia today: select * from pg_timezone_abbrevs where abbrev in ('MSK', 'MSD'); abbrev | utc_offset | is_dst --------+------------+-------- MSD | 04:00:00 | t MSK | 04:00:00 | f but, for example, in 2009 it must be different, I think zdump -v Europe/Moscow | grep 2009 Europe/Moscow Sat Mar 28 22:59:59 2009 UTC = Sun Mar 29 01:59:59 2009 MSK isdst=0 gmtoff=10800 Europe/Moscow Sat Mar 28 23:00:00 2009 UTC = Sun Mar 29 03:00:00 2009 MSD isdst=1 gmtoff=14400 Europe/Moscow Sat Oct 24 22:59:59 2009 UTC = Sun Oct 25 02:59:59 2009 MSD isdst=1 gmtoff=14400 Europe/Moscow Sat Oct 24 23:00:00 2009 UTC = Sun Oct 25 02:00:00 2009 MSK isdst=0 gmtoff=10800 and 'Oct 25 02:15 MSD' (Oct 24 22:15:00 UTC) must not be equal to 'Oct 25 02:15 MSK' (Oct 24 23:15:00 UTC) but now it is equal: select 'Sun Oct 25 02:15:00 2009 MSD'::timestamptz = 'Sun Oct 25 02:15:00 2009 MSK'::timestamptz; ?column? ---------- t not sure, is this a bug or feature...
В списке pgsql-bugs по дате отправления: