From: | mark(dot)a(dot)sloan(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #9374: some timzone abbver is missing from pg_timezone_abbrevs that are in pg_timezone_names |
Date: | 2014-02-27 21:52:58 |
Message-ID: | 20140227215258.29537.95425@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: 9374
Logged by: Mark Sloan
Email address: mark(dot)a(dot)sloan(at)gmail(dot)com
PostgreSQL version: 9.3.3
Operating system: CentOS 6.5
Description:
postgres=# SELECT * FROM pg_timezone_names where abbrev = 'WIB' ;
name | abbrev | utc_offset | is_dst
----------------------+--------+------------+--------
posix/Asia/Pontianak | WIB | 07:00:00 | f
posix/Asia/Jakarta | WIB | 07:00:00 | f
Asia/Pontianak | WIB | 07:00:00 | f
Asia/Jakarta | WIB | 07:00:00 | f
(4 rows)
postgres=# SELECT * FROM pg_timezone_abbrevs where abbrev = 'WIB' ;
abbrev | utc_offset | is_dst
--------+------------+--------
(0 rows)
using PGDG rpms.
postgresql-server-9.2.7, or 9.3.3
tzdata-2013i-2
I am not sure if "ALL" of these are supposed to be in pg_timezone_abbrevs.
here is the missing ones.
abbrev
--------
AQTT
CAT
CHOT
CVT
CWST
ChST
ECT
GMT+1
GMT+10
GMT+11
GMT+12
GMT+2
GMT+3
GMT+4
GMT+5
GMT+6
GMT+7
GMT+8
GMT+9
GMT-1
GMT-10
GMT-11
GMT-12
GMT-13
GMT-14
GMT-2
GMT-3
GMT-4
GMT-5
GMT-6
GMT-7
GMT-8
GMT-9
GST
HAST
HOVT
IRST
MIST
MeST
NCT
NRT
ORAT
QYZT
ROTT
SAKT
SAMT
SBT
SRT
SST
SYOT
TLT
VOST
WIB
WIT
WITA
WSDT
WST
(57 rows)
the WIB one is giving me grief, I am going to push that we convert to always
using timezone names rather than abbreviations, but this looked odd to me.
From | Date | Subject | |
---|---|---|---|
Next Message | jenifersouza8 | 2014-02-28 00:09:25 | BUG #9376: erro na instalação |
Previous Message | shivshi | 2014-02-27 21:43:20 | Re: PostgreSQL 6.2.5 Visual Studio Build does not pass the regression tests. |