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 1pIFGF-0000Bn-0p for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 20:42:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pIFGD-0001CR-IF for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 20:42:17 +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 1pIFGD-0001CI-Ba for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 20:42:17 +0000 Received: from mail-il1-x132.google.com ([2607:f8b0:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pIFGA-00079s-US for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 20:42:16 +0000 Received: by mail-il1-x132.google.com with SMTP id i17so136356ila.9 for ; Wed, 18 Jan 2023 12:42:14 -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=QhDfGzUI2LMO1kcaIvJcVVnIT27jITXsfuTty2u7/YU=; b=lDLHHAEHRRxAnlQNhuLETRZucuzXlNhREBns9wXNPiQeK7liINS6+tOzg9o2RlGA3o pv1Zo+Juxr2EAEZOpa36dB2/ZlyTQ2ADGdyVxlGhs+jpOVjveEaPwEtKJHgMwmNjLBPY 138CeCCDgQG5KknNoy32eY0u8++IAvC8DFDTRNtqeQi/W4keSG97pNksZOtD9e1f46Wo UFYUyBhUeAEYMX0QC53yXPLmp/WHTzRI7bM3WjsfPQ+nXSF3lYd9plNvMN2gSBe74qtc LIf51mOowOgV2box+4apkshAOwMwVV4AEpi7Qgs9yauXMUP2HedGs4MCksku+NytPK0U Hd1w== 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=QhDfGzUI2LMO1kcaIvJcVVnIT27jITXsfuTty2u7/YU=; b=LnsDmlxuHh+hj/kyFFEl+K3oYFMY9ZK8W+0IbT5zsQQ0oT4umeI5rj1cfooBxT/Kuq 20s9tPdpcSjWskfZmR69g9+NwPnKUzH4EqWhQxq1/ZRKmII98mU5d/D6avBuVfCvfJKU i3SRrF/rg3dIXu8wF12Edg2m6OD1cw3kL48xVlK6Tc18mjIeaRAz55t/rz2DYMIDkp9j 1f6pickEuU3v/aGLU0IDcGrmhEKjCHJPHSmXokUFZZuQmfdchMp1f9dN2kxPX2m0toz2 PZTeeDxlfqC8u6qERspVLcOFmay1Fz0RA2GMdNdbA0s8+wHiGcPtKbuzd5AvryMcN5iJ Dq9Q== X-Gm-Message-State: AFqh2ko2uM7+dcDhl/U9lBeqtjHIUwzopzUwMX3tg5vAXTWMELIfsJUY nluD86EAcMkFvZA4U7YH5heErQ== X-Google-Smtp-Source: AMrXdXv5tGCXZLJH9WHdnzm7h/YBBR7+mdC4WFkh1VD2ygsePpEklwOkvpFfYkGzOR6wHQTqXHztHQ== X-Received: by 2002:a92:ce89:0:b0:30d:b90d:c0cf with SMTP id r9-20020a92ce89000000b0030db90dc0cfmr6925960ilo.29.1674074533302; Wed, 18 Jan 2023 12:42:13 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id b32-20020a0295a3000000b003a4b24f08d4sm3216103jai.165.2023.01.18.12.42.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 18 Jan 2023 12:42:12 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id B8548800ED9; Wed, 18 Jan 2023 14:42:11 -0600 (CST) Date: Wed, 18 Jan 2023 14:42:11 -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: <20230118204211.GA23463@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> <20230118204006.GB9837@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230118204006.GB9837@telsasoft.com> 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 02:40:06PM -0600, Justin Pryzby wrote: > 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 Correction. It failed in the most recent 7 runs, which seem to be ~13 days ago through ~7 days ago, when its cfapp record was closed. 2023-01-12 01:06:50 Tom Lane (tgl) Closed in commitfest 2023-01 with status: Committed > I also saw that it failed in its previous incarnation, before the > revert, but didn't dig into it at that point.