Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6Ze5-000RLt-74 for pgsql-general@arkaria.postgresql.org; Mon, 13 May 2024 17:39:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s6Zd7-002udj-7N for pgsql-general@arkaria.postgresql.org; Mon, 13 May 2024 17:38:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6Zd6-002uat-Rm for pgsql-general@lists.postgresql.org; Mon, 13 May 2024 17:38:28 +0000 Received: from smtp68.iad3a.emailsrvr.com ([173.203.187.68]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6Zd4-000250-GQ for pgsql-general@lists.postgresql.org; Mon, 13 May 2024 17:38:27 +0000 X-Auth-ID: xof@thebuild.com Received: by smtp9.relay.iad3a.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 2FF0656E3 for ; Mon, 13 May 2024 13:38:25 -0400 (EDT) From: Christophe Pettus Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.500.171.1.1\)) Subject: UTC is not a time zone? Message-Id: <327870A4-F35C-462C-9F64-E0838374AFDF@thebuild.com> Date: Mon, 13 May 2024 10:37:54 -0700 To: "pgsql-generallists.postgresql.org" X-Mailer: Apple Mail (2.3774.500.171.1.1) X-Classification-ID: bb5db0c0-0b5b-4ea4-9adc-a7c5d9a011ad-1-1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PostgreSQL 16.3 on MacOS Sonoma. A long-running process (which held a = connection open the entire time) failed with: 2024-05-13 09:12:44.719 = PDT,"cyan","cyan",35926,"[local]",664214f9.8c56,3,"SELECT",2024-05-13 = 06:26:17 PDT,3/444460,0,ERROR,22023,"invalid value for parameter = ""TimeZone"": ""UTC""",,,,,"while setting parameter ""TimeZone"" to = ""UTC"" parallel worker"," select count(1), count(1) filter (where visited > 0) = from framework_seenchoice ",,,"","client backend",,0 It's not (easily) repeatable, and the system was not touched while the = process was running (no installing new binaries, etc.). Does this look = familiar to anyone?=