Re: BUG #9374: some timzone abbver is missing from pg_timezone_abbrevs that are in pg_timezone_names
От | ..: Mark Sloan :.. |
---|---|
Тема | Re: BUG #9374: some timzone abbver is missing from pg_timezone_abbrevs that are in pg_timezone_names |
Дата | |
Msg-id | CANahebOjX4cjgner0u=_ftY0YK2aXUfBjhf4hrF6sdtmhG3YRA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: BUG #9374: some timzone abbver is missing from pg_timezone_abbrevs that are in pg_timezone_names (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-bugs |
On Fri, Feb 28, 2014 at 6:57 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > mark.a.sloan@gmail.com writes: > > 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) > > This is not a bug. pg_timezone_abbrevs only lists abbreviations that are > listed in the file selected by the timezone_abbreviations parameter. > The default file doesn't contain WIB. You can if you like add it, > or maybe better make up a custom abbreviations file tuned to your > particular needs While we haven't got a hard and fast policy about which timezone > abbreviations to list in the default set, there are good reasons not to > list uncommonly used ones: the more abbreviations are in the file, the > greater chance of accepting typos as valid input. And we're definitely > going to be cautious about including abbreviations that mean different > things in different parts of the world, which is an issue for several of > the "missing" ones you listed. > > regards, tom lane > Thank you for the clarification. I think it's going to better for the groups I work with to just use the long name rather than the abbreviations. -Mark
В списке pgsql-bugs по дате отправления: