Re: Strange timezone 'math' in 9.6.8 - Mailing list pgsql-admin

From Tom Lane
Subject Re: Strange timezone 'math' in 9.6.8
Date
Msg-id 19863.1522246651@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange timezone 'math' in 9.6.8  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Strange timezone 'math' in 9.6.8  (Ervin Weber <webervin@gmail.com>)
List pgsql-admin
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> Ervin Weber wrote:
>> staging=# select now(), now() at time zone 'fubar+167';
>> [works]
>> staging=# select now(), now() at time zone 'fubar+168';
>> ERROR:  time zone "fubar+168" not recognized

> The cause of the error is the following code in src/timezone/localtime.c,
> in function "getsecs":

Also note that that isn't our code; it's lock stock and barrel from the
IANA tzcode distribution,
https://www.iana.org/time-zones

So we are (probably) not the only software that will behave like this.

            regards, tom lane


pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Strange timezone 'math' in 9.6.8
Next
From: Wells Oliver
Date:
Subject: Re: postgres 9.6.8 to 10 on Ubuntu 16.04.4 LTS --- tsearch2 unloadable...