Re: Strange timezone 'math' in 9.6.8

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Ervin Weber <webervin(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Strange timezone 'math' in 9.6.8
Date: 2018-03-28 14:17:31
Message-ID: 19863.1522246651@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2018-03-28 16:15:58 Re: postgres 9.6.8 to 10 on Ubuntu 16.04.4 LTS --- tsearch2 unloadable...
Previous Message Laurenz Albe 2018-03-28 11:50:46 Re: Strange timezone 'math' in 9.6.8