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 1pIEaP-0005un-J4 for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 19:59:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pIEaO-0004iD-EP for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 19:59:04 +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 1pIEaM-0004ft-LT for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 19:59:04 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pIEaJ-0002OC-1Q for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 19:59:01 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 079CC320093E; Wed, 18 Jan 2023 14:58:56 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Wed, 18 Jan 2023 14:58:57 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm3; t=1674071936; x=1674158336; bh=ftQBu2wh7a 2yXTekyrBNU390iIbRyc5Y7wlPiU1G/dA=; b=ToDyR/VsgXP9Y6WKJ1tMfp2mq7 i3B6aHjcMED1tTX4WD+3YdcfFQ1jBoEK4U3qiog8I8hmAVSXWFAsc81eQrrAvhUa pCSLgM//jrZrZEuHqveFywLKGEGjP5M3zEYvjKsQjBUxBVcLmzUW0+zkuLcq75k2 JsAYd/coIx68IYQTxdcVwjBi3kTPPjJLRkyyJFa3d10ufxL5cre/FrjAHPuQ/Fqk G8m/PgAjUcXha4VXTRWgCU2btkBTY9Gjf5mk6IQ553JT31BZR10GWQzqFAQ9qflm PEFyuEwpEEC7EuY6OnQZAOfMVINFxLE8h7y3cRSyW+Tjgf14YGOnaeAhGOdw== 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= fm3; t=1674071936; x=1674158336; bh=ftQBu2wh7a2yXTekyrBNU390iIbR yc5Y7wlPiU1G/dA=; b=IYpoIfxwV6pLRYIszQlz9t5H3PeGTL27BcVlApuKixbW W/EFyIlo6+VvyKXlV3gahbmABqYsNe4iLxtMlpnbTTeQJ2a9K5qQQoAmPKvnplQW t5xqiohN0PWN/yjlS/7elmBlGmTpTvqCmnXUM8aR4Nm/5ur6DX93e4qmmieDyNRt 8gZUDZV2+AerHGlQ57KzqyhWtmImqxnMRkkdQDLY87ZLlfm2IZ1jdvtm9lME3PnT p0H27+ItuJFiomkAtmaZyp1DJKe/xQBMhlx7cZmFNU23I4H7pGji6qVx0dwKDS8y Cw3fcTpoYktrw+zSuffcSFnCL1CsKWTt37y6W6qR+g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedruddtkedgudefudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecunecujfgurhepfffhvfevuffkfhggtggujgesth dtredttddtvdenucfhrhhomheptehnughrvghsucfhrhgvuhhnugcuoegrnhgurhgvshes rghnrghrrgiivghlrdguvgeqnecuggftrfgrthhtvghrnhephfegjedtudegveffteefje eljedvgeetueelffdtffejgeffgeeggeffteegheeunecuffhomhgrihhnpegtihhrrhhu shdqtghirdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilh hfrhhomheprghnughrvghssegrnhgrrhgriigvlhdruggv X-ME-Proxy: Feedback-ID: id4a34324:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 18 Jan 2023 14:58:56 -0500 (EST) Date: Wed, 18 Jan 2023 11:58:55 -0800 From: Andres Freund To: Tom Lane Cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Get rid of the "new" and "old" entries in a view's rangetable. Message-ID: <20230118195855.7yjc4mminmv7iyy5@awork3.anarazel.de> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2023-01-18 18:24:45 +0000, Tom Lane wrote: > Get rid of the "new" and "old" entries in a view's rangetable. This seems to have caused a test failure on windows. Looks like it's not indicating a real problem, just that collate.windows.win1252.out needs to be adapted. Here's the regression.diffs: https://api.cirrus-ci.com/v1/artifact/task/6607289507905536/testrun/build/testrun/regress/regress/regression.diffs Full test: https://cirrus-ci.com/task/6607289507905536 The other failures are just due to the main regression tests being "embedded". Greetings, Andres Freund