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 1og7b6-00042l-1w for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Oct 2022 16:50: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 1og7b4-0001G9-E5 for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Oct 2022 16:50: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 1og7b3-0001Fz-H9 for pgsql-hackers@lists.postgresql.org; Wed, 05 Oct 2022 16:50:14 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1og7ay-0000Ju-RG for pgsql-hackers@postgresql.org; Wed, 05 Oct 2022 16:50:13 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id D0AA932009AF; Wed, 5 Oct 2022 12:50:03 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Wed, 05 Oct 2022 12:50:04 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:reply-to:sender :subject:subject:to:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1664988603; x=1665075003; bh=G EQ/iYspFrtkd7L+kCetDdkS5EghqX/ugmc4LYL2tA8=; b=wxlJVEEII3HuRuDhf 37ly6kUcjtr6p/qXeAZrvTkDlGgOo70I/tjwxeiHNqwKyUQguLiML3IaBASK3itq vzP58NgcL6+uuzzHQIvtz0cD+WA5AGPKuhqh/2iBnw+3oZGwgbuSzJx3NFCygV1h FmxiTIz1e77/IHOiYjww9cfJrI/+AztvTBRLwSLA45YDILAJqfcJHr5PJ6sexKP4 6g7xx44q57Xe6jzDksbr0wqqI8ABmm36TRV7BvkpDtshiZILpD8zLvpkmBvS/e19 lfYkT8S8Upitst035mv2bJxH90Yp5Meqvk3Xkg7JQf1uymSMcKDgua5QXOZeT5f+ jbIIw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrfeeifedguddthecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhv rghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorh hgqeenucggtffrrghtthgvrhhnpefgtdegleeggffftdeiuddufffhveekgfdufeethefg tefhkedvgeejlefhteehvdenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtoh hmpdhpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgr rhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorh hg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 5 Oct 2022 12:50:02 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 9F80D62; Wed, 5 Oct 2022 18:40:48 +0200 (CEST) Date: Wed, 5 Oct 2022 18:40:48 +0200 From: Alvaro Herrera To: Jehan-Guillaume de Rorthais Cc: Zhihong Yu , pgsql-hackers Subject: Re: [BUG] parenting a PK constraint to a self-FK one (Was: Self FK oddity when attaching a partition) Message-ID: <20221005164048.exmpnpqzfkrgmqtx@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20221005105523.bhuhkdx4olajboof@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Backpatching this to 12 shows yet another problem -- the topmost relation acquires additional FK constraints, not yet sure why. I think we must have fixed something in 13 that wasn't backpatched, but I can't remember what it is and whether it was intentionally not backpatched. Looking ... -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "I can see support will not be a problem. 10 out of 10." (Simon Wittber) (http://archives.postgresql.org/pgsql-general/2004-12/msg00159.php)