From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Ervin Weber <webervin@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Strange timezone 'math' in 9.6.8
Date: Wed, 28 Mar 2018 10:17:31 -0400
Message-ID: <19863.1522246651@sss.pgh.pa.us> (raw)
In-Reply-To: <1522237846.2820.26.camel@cybertec.at>
References: <CAFC4ZFjoVMbFqgj9O0Bz+YSnrfzHrEFWHi-fa1bmWmadfnN6iw@mail.gmail.com>
<1522237846.2820.26.camel@cybertec.at>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, laurenz.albe@cybertec.at, webervin@gmail.com
Subject: Re: Strange timezone 'math' in 9.6.8
In-Reply-To: <19863.1522246651@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox