BUG #10112: Timezone abbrevs and it history

From: eshkinkot(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #10112: Timezone abbrevs and it history
Date: 2014-04-23 00:15:35
Message-ID: 20140423001535.2714.89878@wrigleys.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: 10112
Logged by: Sergey Burladyan
Email address: eshkinkot(at)gmail(dot)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...

Browse pgsql-bugs by date

  From Date Subject
Next Message bmashkoor 2014-04-23 19:48:52 BUG #10116: Unable to load more than 100 recs - trial version
Previous Message Bruce Momjian 2014-04-22 19:47:50 Re: BUG #9416: Setting up postgresql-9.1 (9.1.12-0wheezy1) Fails Configuration