Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rWvfK-007sQj-8e for pgsql-hackers@arkaria.postgresql.org; Mon, 05 Feb 2024 09:53:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rWvfJ-00COnz-Er for pgsql-hackers@arkaria.postgresql.org; Mon, 05 Feb 2024 09:53:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rWvfI-00COnq-Bo for pgsql-hackers@lists.postgresql.org; Mon, 05 Feb 2024 09:53:25 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rWvfF-005AhE-GM for pgsql-hackers@lists.postgresql.org; Mon, 05 Feb 2024 09:53:23 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 93E783200A42; Mon, 5 Feb 2024 04:53:19 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Mon, 05 Feb 2024 04:53:20 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1707126799; x= 1707213199; bh=4Zj3qorQJ4mjquUnuJ6N9prk+8JdFM5+/FpTzsM5iTo=; b=w cje4EqYtoR97jefKnmEYYTRJ/Ym5rTRlpXts3hlHz/SZVipLFyB5THyvW98q7ntZ RbAFcG+x7MQR7ygsYSahwUa8ppUVtEKz0uCUsgCU286FnKPpM9DO2vclLvIeDm0y 3qtWCLxlB/NhkQf4hzmGTYs/jSMfoESsG7V5Gz7BZZ2al7jRj1KgfeAqrArKTiIN 0C/aQ0t/Lssyz2yio/qTY3DAmrtUlyiEczQJrpsSNKV5c5l+tD/afddHIVCMKQcR 6ai3ejyg5fcJsOG6FvO9CAvMpnVt0a3WuOjhUBA+nMNnZCyaOdUtSD6h/DgYp6/6 neDv4UuBtRh/23LFRtqdQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrfedvtddgtdelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhepvdektdffudfftdffffehfffhjeejhffgieeuueekjeek fffgudffhfduffffueevnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomh enucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhv hhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 5 Feb 2024 04:53:18 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1707126797; bh=FnjtjtSkVQjy6T8Lv10sbnpHmyDHgEEzGUKSVhOsHoU=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=nUzqLAMG+FbVMhU9Sv6Hjj8eoQ6JNpHSXFdLoUByZG7Houo+JylsDpPsXKLjM7TjG mmzFPvL4C6U18+f/o4TPg+EG9wDWVyPHg28F8mAIiCveHsbDUuZMwJXUwGoZ61SCTm ifcZlQirNaUYiG6cwphvQk2u6Ot9Xs9Xy35hl4uNgcnVBbVS7vi34KLnIPGssnqgM2 gHVy1TPaB+wAxL9x0FYcbHRLWtZHN82xH5WGxQZ6nxNjkVIr7OFn2DP6J0JlP2Zb4z ZC06F8qXIKrsSH/6u1hzuNMRQTagtx9jzU8MGK2G8HiZB7kvbTyMjf2Y6PAtrIxWdC fX6gaYhSSO8XA== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id A3878BA3; Mon, 5 Feb 2024 10:53:17 +0100 (CET) Date: Mon, 5 Feb 2024 10:53:17 +0100 From: Alvaro Herrera To: Michael Paquier Cc: Alexander Lakhin , Dean Rasheed , Peter Eisentraut , Robert Haas , pgsql-hackers@lists.postgresql.org Subject: Re: cataloguing NOT NULL constraints Message-ID: <202402050953.vxb2dfgzimht@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202402050950.q367e2d6rtjs@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024-Feb-05, Alvaro Herrera wrote: > Subject: [PATCH v1] Fix failure to merge NOT NULL constraints in inheritance > > set_attnotnull() was not careful to CommandCounterIncrement() in cases > of multiple recursion. Omission in b0e96f311985. Eh, this needs to read "multiple inheritance" rather than "multiple recursion". (I'd also need to describe the change for the partitioning cases in the commit message.) -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "Someone said that it is at least an order of magnitude more work to do production software than a prototype. I think he is wrong by at least an order of magnitude." (Brian Kernighan)