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 1pktur-0006qV-DB for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Apr 2023 21:46:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pktuq-0002Tx-Ao for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Apr 2023 21:46:40 +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 1pktuq-0002Pi-16 for pgsql-hackers@lists.postgresql.org; Fri, 07 Apr 2023 21:46:40 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pktun-00014G-Fk for pgsql-hackers@lists.postgresql.org; Fri, 07 Apr 2023 21:46:39 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 337LkXQL3242331; Fri, 7 Apr 2023 17:46:33 -0400 From: Tom Lane To: Andres Freund cc: Alvaro Herrera , Justin Pryzby , Peter Eisentraut , pgsql-hackers@lists.postgresql.org Subject: Re: cataloguing NOT NULL constraints In-reply-to: <20230407211950.aojbdirwdrxjeyzb@awork3.anarazel.de> References: <20230407211000.d2iaklm76djy26nm@awork3.anarazel.de> <20230407211155.qrc2bqgyogvrfkzo@alvherre.pgsql> <20230407211950.aojbdirwdrxjeyzb@awork3.anarazel.de> Comments: In-reply-to Andres Freund message dated "Fri, 07 Apr 2023 14:19:50 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3242329.1680903993.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Fri, 07 Apr 2023 17:46:33 -0400 Message-ID: <3242330.1680903993@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Andres Freund writes: > On 2023-04-07 23:11:55 +0200, Alvaro Herrera wrote: >> Ah, cool, no worries. I would have stopped indeed, but I had to stay >> around in case of any test failures. > Looks like there's work for you if you want ;) > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Drhinoceros&dt=3D= 2023-04-07%2018%3A52%3A13 > But IMO fixing sepgsql can easily wait till tomorrow. I can deal with that one -- it's a bit annoying to work with sepgsql if you're not on a Red Hat platform. After quickly eyeing the diffs, I'm just going to take the new output as good. I'm not surprised that there are additional output messages given the additional catalog entries this made. I *am* a bit surprised that some messages seem to have disappeared --- are there places where this resulted in fewer catalog accesses than before? Nonetheless, there's no good reason to assume this test is exposing any bugs. regards, tom lane