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 1pIEpq-00076d-AI for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 20:15:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pIEpo-0003NU-TW for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 20:15:00 +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 1pIEpo-0003NK-MJ for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 20:15:00 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pIEpm-0006vH-0p for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 20:15:00 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 7F081320095F; Wed, 18 Jan 2023 15:14:53 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Wed, 18 Jan 2023 15:14:53 -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=1674072893; x=1674159293; bh=ZBVb/osqR5 95G5B69OkAHOkSOTqb3qKMHHqTnRrMx08=; b=VI0fTRmXtjElic0LBc9CfaN0yV 1vyRZBBfvO1km0nF1beshyp7GnT1KKUVVcziSf2ZjZu9T3McrOyJYzZgsTdSw9JW awdNR+LpyPWDy7fRMyRtAvq/uzQ5FMh7sBxOXKYP2oR2Ij/RGSODGd9kJf49Sxdo ghtfqAIWsspFdEXbYeRCIfCpX9yj6Sh4WvmAwKkpOr4ne2NteW5KyBaImDQjAS8x CPI+xWmqsqF1mjeRYYoZC2il1qmVhJSINcjGFrkSb91NqtHZRDqzRsz8RQGntcbW AGC5IxlJNFzH2rWdLfUiQnOFLNaEEE2zP8Q5bpHRW/w4nSupxFHgbLtJbCqQ== 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=1674072893; x=1674159293; bh=ZBVb/osqR595G5B69OkAHOkSOTqb 3qKMHHqTnRrMx08=; b=GEVYpmZyk4n8OBES+iXuFuXVC0RyZptczxoUJRyEk8Pk JgddjNhKqxzzAM1A4lxmo18LJWd6953D2UjxVldoijjK9FI/k6rGv/zBOFOjZC4Y tGCJAdoTK9N57FLXuWkm4WGAWtdSpcjxWgdW5G0GMT+6vpHAVE1snepFOnyw7jwS u5ZWouPmjy77bOtvLAABvVOPSuR6QXjBI0z/EHWONN6DXAEOOmBcl72QzCE8W1ap CyAseu2IHf/MYUx0zGQ5sFDENzI4cYb5yXuPJeQVR26AP8wUI4Y4NX47wy05VVSJ 7U5bJ+mEyGs4jz0Ra64Dk6SeEprQNO8D0AMeuYMsWg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedruddtkedgudefgecutefuodetggdotefrod 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 15:14:52 -0500 (EST) Date: Wed, 18 Jan 2023 12:14:51 -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: <20230118201451.f2dooawchsfy57qc@awork3.anarazel.de> References: <20230118195855.7yjc4mminmv7iyy5@awork3.anarazel.de> <3787913.1674072518@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3787913.1674072518@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2023-01-18 15:08:38 -0500, Tom Lane wrote: > Andres Freund writes: > > 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. > > Huh, I wonder why the cfbot never complained about that when > it was testing this patch ... maybe it doesn't use win1252? This is the same environment that cfbot is also using, so this is odd. And cfbot has been failing on windows since the commit went into master: https://cirrus-ci.com/github/postgresql-cfbot/postgresql/ So I guess something must have changed in the patch since then? I guess it could be that something changed on the VM, but I don't think so... Greetings, Andres Freund