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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s6a0e-000Tuf-9p
	for pgsql-general@arkaria.postgresql.org; Mon, 13 May 2024 18:02:49 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s6a0e-003U5g-BG
	for pgsql-general@arkaria.postgresql.org; Mon, 13 May 2024 18:02:48 +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 <xof@thebuild.com>)
	id 1s6a0e-003U5Y-0g
	for pgsql-general@lists.postgresql.org; Mon, 13 May 2024 18:02:48 +0000
Received: from smtp83.iad3b.emailsrvr.com ([146.20.161.83])
	by makus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1s6a0b-0002Is-OC
	for pgsql-general@lists.postgresql.org; Mon, 13 May 2024 18:02:46 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp3.relay.iad3b.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 7CF9A4038E;
	Mon, 13 May 2024 14:02:44 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.500.171.1.1\))
Subject: Re: UTC is not a time zone?
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <a4a29ef0-a201-4d35-bd04-57a5e8bda9b2@aklaver.com>
Date: Mon, 13 May 2024 11:02:13 -0700
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <26FEAACB-9A3E-4823-98A9-FB5298822DD8@thebuild.com>
References: <327870A4-F35C-462C-9F64-E0838374AFDF@thebuild.com>
 <63e65356-9cb5-48b7-9bc5-5c734013ebe1@aklaver.com>
 <C430EBE1-EFA9-407D-8830-7C379B24B5AB@thebuild.com>
 <a4a29ef0-a201-4d35-bd04-57a5e8bda9b2@aklaver.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
X-Mailer: Apple Mail (2.3774.500.171.1.1)
X-Classification-ID: 278cefc1-a3b5-4e29-b904-51bfa8121a3c-1-1
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/26FEAACB-9A3E-4823-98A9-FB5298822DD8%40thebuild.com>
Precedence: bulk



> On May 13, 2024, at 10:58, Adrian Klaver <adrian.klaver@aklaver.com> =
wrote:
>=20
> You sure the timezone file did not get changed under the connection?

Yes (at least, nothing happened on the system that would indicate that). =
 The system wasn't touched during the execution (and, as noted, it =
worked after as well as before).

> Why is SET TIMEZONE TO 'UTC being constantly called?

ORM noise.=