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 1oqt0w-0000fG-Hk for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Nov 2022 09:29:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oqt0v-0002hJ-AM for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Nov 2022 09:29:25 +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 1oqt0v-0002hA-0I for pgsql-hackers@lists.postgresql.org; Fri, 04 Nov 2022 09:29:25 +0000 Received: from mail1.dalibo.net ([51.159.93.128] helo=mail.dalibo.com) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oqt0t-0000lD-3h for pgsql-hackers@postgresql.org; Fri, 04 Nov 2022 09:29:24 +0000 Received: from karst (larco.ioguix.net [78.202.0.6]) by mail.dalibo.com (Postfix) with ESMTPSA id 7CDBD1FB46; Fri, 4 Nov 2022 10:29:11 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dalibo.com; s=a; t=1667554151; bh=h26PvogDCRHYQ2esrj9kTcjR0pdhQ6OlwxIF3d4V++A=; h=Date:From:To:Cc:Subject:In-Reply-To:References:From; b=cNvLCA2Mn+8kVcusFvqlCs9S9+R7BQ+cPHbgjdJjX+4FkVBUm2UKKtJYx9wCAtkKG nUdt7wqGinlmj7tY/korawmTmy/aN0vYcKKbggWRczSW4Nzj+yGZQAeGzZ2VaVIk/X iENvc8K6qd0SrRgVhFjME7pmp4EWXrWNgNo7d6ow= Date: Fri, 4 Nov 2022 10:29:10 +0100 From: Jehan-Guillaume de Rorthais To: Alvaro Herrera 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: <20221104102910.641baa78@karst> In-Reply-To: <20221103194416.sdp75teipw4i5hri@alvherre.pgsql> References: <20221005105523.bhuhkdx4olajboof@alvherre.pgsql> <20221103194416.sdp75teipw4i5hri@alvherre.pgsql> Organization: Dalibo MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 3 Nov 2022 20:44:16 +0100 Alvaro Herrera wrote: > On 2022-Oct-05, Alvaro Herrera wrote: > > > I've been giving the patches a look and it caused me to notice two > > additional bugs in the same area: > > > > - FKs in partitions are sometimes marked NOT VALID. This is because of > > missing initialization when faking up a Constraint node in > > CloneFkReferencing. Easy to fix, have patch, running tests now. > > I have pushed the fix for this now. Thank you Alvaro!