BUG #14352: Error in Time Zone abbreviations
The following bug has been logged on the website:
Bug reference: 14352
Logged by: Isaias Sanchez
Email address: isaias.sanchez.l@gmail.com
PostgreSQL version: 9.4.9
Operating system: Linux - Centos 6.8 - Kernel 2.6.32
Description:
Any query over a the view: pg_timezone_abbrevs returns error.
postgres=# SELECT * FROM pg_timezone_abbrevs;
ERROR: time zone abbreviation "novst" is not used in time zone
"Asia/Novosibirsk"
I have tested in: 9.2.18, 9.3.14, 9.4.9 and 9.5.4 but it works fine in
9.6.0.
Also seems to work fine in Centos 6.6.
I don't know why the OS affect this if the timezone is taken from
share/timezonesets/
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
isaias.sanchez.l@gmail.com writes:
Any query over a the view: pg_timezone_abbrevs returns error.
Yeah, this was previously reported and will be fixed in the next
point releases. In the meantime, you could work around it by
removing the failing entries from share/timezonesets/Default.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Thank you for your help.
Isaias S.
El mar., 4 oct. 2016 17:31, Tom Lane <tgl@sss.pgh.pa.us> escribió:
Show quoted text
isaias.sanchez.l@gmail.com writes:
Any query over a the view: pg_timezone_abbrevs returns error.
Yeah, this was previously reported and will be fixed in the next
point releases. In the meantime, you could work around it by
removing the failing entries from share/timezonesets/Default.regards, tom lane