From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
cc: Ervin Weber <webervin@gmail.com>, pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Strange timezone 'math' in 9.6.8
In-reply-to: <1522237846.2820.26.camel@cybertec.at>
References: 
 <CAFC4ZFjoVMbFqgj9O0Bz+YSnrfzHrEFWHi-fa1bmWmadfnN6iw@mail.gmail.com>
 <1522237846.2820.26.camel@cybertec.at>
Comments: In-reply-to Laurenz Albe <laurenz.albe@cybertec.at>
	message dated "Wed, 28 Mar 2018 13:50:46 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <19862.1522246651.1@sss.pgh.pa.us>
Date: Wed, 28 Mar 2018 10:17:31 -0400
Message-ID: <19863.1522246651@sss.pgh.pa.us>
Precedence: bulk

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