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 1oKQ2B-00041g-NO for pgsql-committers@arkaria.postgresql.org; Sat, 06 Aug 2022 20:04:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oKQ28-0007NJ-Ts for pgsql-committers@arkaria.postgresql.org; Sat, 06 Aug 2022 20:04:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oKQ28-0007N8-1b for pgsql-committers@lists.postgresql.org; Sat, 06 Aug 2022 20:04:28 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oKQ23-0006r9-Am for pgsql-committers@lists.postgresql.org; Sat, 06 Aug 2022 20:04:25 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 4666D3200488; Sat, 6 Aug 2022 16:04:19 -0400 (EDT) Received: from imap47 ([10.202.2.97]) by compute2.internal (MEProxy); Sat, 06 Aug 2022 16:04:19 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:feedback-id :feedback-id:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; t=1659816258; x=1659902658; bh=CkmmsnJUANgk8R6w/PteO3MT6Jaq qzHIOWLB2LMzGEU=; b=yJvIiuJ6FoRGzzkbBFFoPfA7AeHqBwnKcUi4f2MQUOUR cpXRD9FJuNmRMf8Xy93JwpPNCpojZp+phDX5BILk/k9ofMmcTHhoOPmQ8XO+6H0u nMg+kokFEFD5jwZ/YBX+sFDDj3+Alq1WCRt0wBxUQ5ZtVypeH+kLBn3nxCVjRPg9 MiOPKUu/aoWLiN1n8gsvpAuz6uVKGWSycWd2jGXpUDmD18c5b57UvLvCXX+sphkJ nq+IHaVqYyfRxFUjK2fK19jMFT+xy+fjQC5Kr11QLEcOWDU+GUwd9TvZn2Ve81JW yvE/jEDeS3hXolXKRQbR/miB+l5vkFgX5DyBn1bk8Q== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrvdeffedgudegkecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecunecujfgurhepofgfggfkjghffffhvfevufgtse grtderreerreejnecuhfhrohhmpemllhhvrghrohgpjfgvrhhrvghrrgcuoegrlhhvhhgv rhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqeenucggtffrrghtthgvrhhnpeegtdfftd elieegffeitdeihfffgeetleduhfegffegveduheelffdvkeehgeejieenucevlhhushht vghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrg hlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id 45C9CA6007C; Sat, 6 Aug 2022 16:04:18 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.7.0-alpha0-758-ge0d20a54e1-fm-20220729.001-ge0d20a54 Mime-Version: 1.0 Message-Id: In-Reply-To: <129951.1659812518@sss.pgh.pa.us> References: <129951.1659812518@sss.pgh.pa.us> Date: Sat, 06 Aug 2022 22:03:55 +0200 From: =?UTF-8?Q?=C3=81lvaro_Herrera?= To: "Tom Lane" Cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: BRIN: mask BRIN_EVACUATE_PAGE for WAL consistency checking Content-Type: multipart/alternative; boundary=9acdf60ce9d244cbafa3b3346adf096f List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --9acdf60ce9d244cbafa3b3346adf096f Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: quoted-printable On Sat, Aug 6, 2022, at 9:01 PM, Tom Lane wrote: > snapper doesn't like this too much, because >=20 > error running SQL: 'psql::17: ERROR: time zone "america/punta_= arenas" not recognized > CONTEXT: PL/pgSQL function inline_code_block line 3 during statement = block local variable initialization' >=20 > Is there a particular reason why you used that zone, rather than say U= TC? None very good =E2=80=94 I just wanted it to be not Moscow, which it was= in the OP. I'll change it =E2=80=94 to UTC, I suppose. --9acdf60ce9d244cbafa3b3346adf096f Content-Type: text/html;charset=utf-8 Content-Transfer-Encoding: quoted-printable
On Sat, Aug 6, 2022, at 9:01 PM, Tom Lan= e wrote:
=
snapper doesn't like this too much, because

error running SQL: 'psql:<stdin>:17: ERROR:  time zone = "america/punta_arenas" not recognized
CONTEXT:  PL/pg= SQL function inline_code_block line 3 during statement block local varia= ble initialization'

Is there a particular r= eason why you used that zone, rather than say UTC?

None very good =E2=80=94 I just wanted it to be not= Moscow, which it was in the OP. I'll change it =E2=80=94 to UTC, I supp= ose.
--9acdf60ce9d244cbafa3b3346adf096f--