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.96) (envelope-from ) id 1wQKy4-001SlN-2z for pgsql-hackers@arkaria.postgresql.org; Fri, 22 May 2026 08:10:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wQKy0-00Cfpf-2Z for pgsql-hackers@arkaria.postgresql.org; Fri, 22 May 2026 08:10:49 +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.96) (envelope-from ) id 1wQKy0-00CfpW-1K for pgsql-hackers@lists.postgresql.org; Fri, 22 May 2026 08:10:49 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wQKxy-00000000F3Y-1efq for pgsql-hackers@lists.postgresql.org; Fri, 22 May 2026 08:10:48 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id C2A89594933 for ; Fri, 22 May 2026 10:10:42 +0200 (CEST) Received: from s981.loopia.se (unknown [172.22.191.5]) by s807.loopia.se (Postfix) with ESMTP id AC111594061; Fri, 22 May 2026 10:10:42 +0200 (CEST) Received: from localhost (unknown [172.22.191.6]) by s981.loopia.se (Postfix) with ESMTP id A412022B1782; Fri, 22 May 2026 10:10:42 +0200 (CEST) X-Virus-Scanned: amavis at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1.2 X-Spam-Level: X-Spam-Status: No, score=-1.2 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1] autolearn=disabled Authentication-Results: s474.loopia.se (amavis); dkim=pass (2048-bit key) header.d=proxel.se Received: from s934.loopia.se ([172.22.191.6]) by localhost (s474.loopia.se [172.22.190.14]) (amavis, port 10024) with UTF8LMTP id Zew47AgMMAnR; Fri, 22 May 2026 10:10:42 +0200 (CEST) X-Loopia-Auth: user X-Loopia-User: andreas@proxel.se X-Loopia-Originating-IP: 147.28.75.140 Received: from [192.168.0.121] (customer-147-28-75-140.stosn.net [147.28.75.140]) (Authenticated sender: andreas@proxel.se) by s934.loopia.se (Postfix) with ESMTPSA id 2E353917F09; Fri, 22 May 2026 10:10:42 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=proxel.se; s=loopiadkim1707418970; t=1779437442; bh=H2F0XvQ7ja9m9CtE28Pb3J9mJXpGa6A99maMJ5yGjmU=; h=Date:Subject:To:Cc:References:From:In-Reply-To; b=iJwkyGF6ae26A4YnZCYZnrCQvPYaa1wN51lmOm9uJHIe06+EH6/G3asuJyk0my2X0 kWpo+bwcGbKk32CF+UCnCCEWxx6XaLu0I4bxIsPZdVxdvgGXB42NkxbKVTEJwADyo6 ubWUmLq1aYFcPQQNxI2kzpj6gGfMMawxWNEYZpyAmu/YjlXnh8LJxPp1gllTbRVJop M7dyFm0ZGoYhvaybQuaSSiTxYFmt6lg0jODjvMm4Wdph+VBD8YQSeXyBvTy7jMbuuW Tbx1948ysZzvf8Lg5XLnOP1YTMcsVd6NRuii4qJYAidx776sDRt0ZYn+X4WtU80UI5 +EmWe1vHU2MIw== Message-ID: Date: Fri, 22 May 2026 10:10:41 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Prevent setting NO INHERIT on partitioned not-null constraints To: Fujii Masao Cc: Jim Jones , PostgreSQL Hackers References: <24bfd6b7-d566-490c-812f-c61c9eb2ef69@uni-muenster.de> <7299e1c3-9cf5-4e72-94ae-1771d88fb0a3@proxel.se> From: Andreas Karlsson Content-Language: en-US In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 5/22/26 3:10 AM, Fujii Masao wrote: > This should be backpatched to v18, where ALTER TABLE ... ALTER > CONSTRAINT ... [NO] INHERIT > was added. Right? Yes, as this is a bug I think it should be backpatched to 18. -- Andreas Karlsson Percona