BUG #14352: Error in Time Zone abbreviations

From: isaias(dot)sanchez(dot)l(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14352: Error in Time Zone abbreviations
Date: 2016-10-04 10:16:55
Message-ID: 20161004101655.27235.87321@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: 14352
Logged by: Isaias Sanchez
Email address: isaias(dot)sanchez(dot)l(at)gmail(dot)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/

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Zuk, Kacper 2016-10-04 11:08:48 Re: BUG #14329: libpq doesn't send complete client certificate chain on first SSL connection
Previous Message Haribabu Kommi 2016-10-04 07:37:25 Re: BUG #14350: VIEW with INSTEAD OF INSERT TRIGGER and COPY. Missing feature or working as designed.