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 1pIFEG-00004u-H8 for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 20:40:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pIFEE-0008Ix-Sh for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 20:40:14 +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 1pIFEE-0008Io-I4 for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 20:40:14 +0000 Received: from mail-io1-xd32.google.com ([2607:f8b0:4864:20::d32]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pIFEB-00078N-KK for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 20:40:13 +0000 Received: by mail-io1-xd32.google.com with SMTP id 203so28200iou.13 for ; Wed, 18 Jan 2023 12:40:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=iq62EJPKxOqJ6yYHJFHy6Pf3gROZvwvse2WRLqch5L8=; b=XahFSxolFCto3Nipc1osmQAx+q53IbYyS2cy1ui+fMuQskowG1+oSF+b0LjHHGAOgL dpjtmowWRhpMggrP1M/W1VaNT0DV7Z1wzdI4oVsEX5pK9Qm5QCIvWdFl6Ru5llLycoXg aZTzaBi1PSNl3JlTzzOzYLQJo46GrI+X9BjnYIa1A+Bl38GEWQsbDlTqbH0yB2cmB5Rv Sow1h6XU4fyILzmj1FREm1l5Zs6CarsuXriAU+2e7xO6c2B2Cb174Bt0YFbFT+1TT02M 8k8qD2nztBTnxQ2tS9oGYWhJ4nKwcYYOEYckZXCrHWzy369UoDOhEr4Qsa1sabLCo73A wOdA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=iq62EJPKxOqJ6yYHJFHy6Pf3gROZvwvse2WRLqch5L8=; b=Pft2lOyQm4nlYlfkXeAY8I1xjbNmqxN63ONCAS/5One2/RwDKc8mTXeFbk8eZutwlR aL1LrSSuPIMrFwcDJDUfiqvxTHA40LNiBpCgezsMyENqU32QFPB+7EFel6NzAo1lEg77 pxt1FTf3c7izWm5eX3FiB3QZBz3St1dOj52Wchl9F0b4B2Tpx0J/a7hMd9qZJeBeF+EI cyzoJdZUeMtucXnLczgqAjovkAkcDM1sdMp1pxqA5yKPmvcWrHSNpduxy9JZDSAEhnsb Di7Glru902PQKyBaYUyCjHMlu2pDzjRUjrNJI+8nrC1bvP47qKlNqVUeIvbiRe2QN/t8 iQuQ== X-Gm-Message-State: AFqh2krKAu10T9bkiHKNXPPm+MPZquZ9xLxLSu8YENBQhhufgGl4H+9E IbYxO0UFB0/UgIAHTcHn29Mprgx6u+f7wbwj X-Google-Smtp-Source: AMrXdXsv+h2rkCCyn3ScnJHvM9R9yZja2eeg7Lb9OKlWVemKnp4KVNJK96EaoOdfzbbU3dMKFF6Ynw== X-Received: by 2002:a05:6602:721:b0:707:6cfe:e19c with SMTP id g1-20020a056602072100b007076cfee19cmr577343iox.10.1674074409592; Wed, 18 Jan 2023 12:40:09 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id p15-20020a0566022b0f00b006e00556dc9esm11780390iov.16.2023.01.18.12.40.09 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 18 Jan 2023 12:40:09 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 08BD3800ED9; Wed, 18 Jan 2023 14:40:06 -0600 (CST) Date: Wed, 18 Jan 2023 14:40:06 -0600 From: Justin Pryzby To: Tom Lane Cc: Andres Freund , pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Get rid of the "new" and "old" entries in a view's rangetable. Message-ID: <20230118204006.GB9837@telsasoft.com> References: <20230118195855.7yjc4mminmv7iyy5@awork3.anarazel.de> <3787913.1674072518@sss.pgh.pa.us> <20230118201451.f2dooawchsfy57qc@awork3.anarazel.de> <3804194.1674074141@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3804194.1674074141@sss.pgh.pa.us> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jan 18, 2023 at 03:35:41PM -0500, Tom Lane wrote: > Andres Freund writes: > > On 2023-01-18 15:08:38 -0500, Tom Lane wrote: > >> 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... > > Hmmm ... the collate.windows.win1252 test did not exist at all before > 3-Jan (bf03cfd16), while 1b4d280ea went in on 11-Jan. So perhaps the > most plausible theory is that the cfbot didn't test this patch between > those dates. It should certainly have noticed if it did run it ... Looks like it failed the last 7 days https://cirrus-ci.com/github/postgresql-cfbot/postgresql/commitfest/41/4048 I also saw that it failed in its previous incarnation, before the revert, but didn't dig into it at that point.