Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ls9dl-0000dq-LL for pgsql-docs@arkaria.postgresql.org; Sat, 12 Jun 2021 19:49:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ls9dk-00048H-7Q for pgsql-docs@arkaria.postgresql.org; Sat, 12 Jun 2021 19:49:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ls9dk-000489-1g for pgsql-docs@lists.postgresql.org; Sat, 12 Jun 2021 19:49:56 +0000 Received: from mail-pl1-x62f.google.com ([2607:f8b0:4864:20::62f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ls9dh-0004kQ-IW for pgsql-docs@lists.postgresql.org; Sat, 12 Jun 2021 19:49:55 +0000 Received: by mail-pl1-x62f.google.com with SMTP id e7so4519798plj.7 for ; Sat, 12 Jun 2021 12:49:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=9czSwC2KaLpp8be5wyydcIyx145MeqdLVYelrN9Xk5g=; b=ZiPY0uK6Q07GI0343/hgqnmk2g2307II+8hn5+yJePXLPgU+Pse9iRc/u76dwZwx19 RLhigfJzfZHYfvUGcjIXLgkqhzIzFYmG+91eAFlu7zu7aU1JprINCopVZWd7Vu0/O/zl OZdVd6nLRDgdynl4/Sw5dnx94p5M4oZdkulMo86OmVSYFwl0d7QuLwcw5HmuyiIeterM QmkeKMmSsghhRGcM0ipcJ4kp/YgcAw6NQXv4HABmADBrVKgL+xwB7ioEfVeWttyvw885 ycTIvJTgV+8BSBZQ51JwxwDHZMx0MIjkpBr+42Fh7UCMetCRW/oSzVWdtCfkNBulUfeh KmDA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=9czSwC2KaLpp8be5wyydcIyx145MeqdLVYelrN9Xk5g=; b=udG6O8ehAOThOHjakUqeCmoQ0l/3R7eYGU1O9Enjb+S6+kMNyNvAJAXzM0DCeezg0m 2VgSO0SuntDKNnvt++/YmIlWMuZCJ2y8cefV+QkfTu0wbeL2g7vF6zMm5cLKqvYoXsOL EEAD4ZdlUeBqM5ErWv7XiporTaB0elSefHD1KSyFvEhFRUXUfdDFSEB0BLLT9684BEoi t9hi2UjfyZCLxDUG+wIKDQDnJyWi39tjwTpgMtXRmjG7Wkm7u7+Tu1+Rx/YLH/JzLc0r 8ElBxy8WgBU/7qx4rGDt+a6p3N6F63169Ea91fnPe0RaQ2JjT3GCwEoUYnSZakidCDeY 3blQ== X-Gm-Message-State: AOAM531XkyIrO/VPo48lvUh8QGToJtpGvUImmLINLRv6YdN66IN1aZfJ xV2+DHqsaKIW7PS8/ssFZOukci1y9439qoNHYAE= X-Google-Smtp-Source: ABdhPJxVdasMe4twd57h16w/rYJYU6XpBxz5WPp3mQlWq3BdZA7DtWqbCWfnN6xFpDpwjhdH0YzK8IO60ZRhQd4Dj1I= X-Received: by 2002:a17:90a:1150:: with SMTP id d16mr10798443pje.180.1623527391069; Sat, 12 Jun 2021 12:49:51 -0700 (PDT) MIME-Version: 1.0 References: <162351129153.14472.70810183330436056@wrigleys.postgresql.org> In-Reply-To: <162351129153.14472.70810183330436056@wrigleys.postgresql.org> From: "David G. Johnston" Date: Sat, 12 Jun 2021 12:49:39 -0700 Message-ID: Subject: Re: TIMEZONE names To: nat@makarevitch.org, Pg Docs Content-Type: multipart/alternative; boundary="0000000000006d8bae05c496edec" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006d8bae05c496edec Content-Type: text/plain; charset="UTF-8" On Sat, Jun 12, 2021, 12:28 PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/datatype-datetime.html > Description: > > The documentation states that some timezone names are recognized. As far > as > I understand others aren't. > > This seems to be true: > $psql postgres -c "set TIMEZONE='bug' ; show timezone;" > ERROR: invalid value for parameter "TimeZone": "bug" > $ echo $? > 1 > > However adding a correct numerical offset leads Postgresql to accept a > non-existing timezone name: > $ psql postgres -c "set TIMEZONE='bug-1' ; show timezone;" > $ echo $? > 0 > That would be the Appendix B material the documentation is referencing. David J. > --0000000000006d8bae05c496edec Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Sat, Jun 12, 2021, 12:28 PG Doc comments form <<= a href=3D"mailto:noreply@postgresql.org">noreply@postgresql.org> wro= te:
The following documentation com= ment has been logged on the website:

Page: https://www.postgresql.org= /docs/13/datatype-datetime.html
Description:

The documentation states that some timezone names are recognized.=C2=A0 As = far as
I understand others aren't.

This seems to be true:
$psql postgres -c "set TIMEZONE=3D'bug' ; show timezone;"=
ERROR:=C2=A0 invalid value for parameter "TimeZone": "bug&qu= ot;
$ echo $?
1

However adding a correct numerical offset leads Postgresql to accept a
non-existing timezone name:
$ psql postgres -c "set TIMEZONE=3D'bug-1' ; show timezone;&qu= ot;
$ echo $?
0

That would be the Appendix B material the documentation is referencing.

David J.
--0000000000006d8bae05c496edec--