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 <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1scCh6-004qsp-44
	for pgsql-bugs@arkaria.postgresql.org; Thu, 08 Aug 2024 23:37:20 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1scCh4-0002WH-7l
	for pgsql-bugs@arkaria.postgresql.org; Thu, 08 Aug 2024 23:37:18 +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 <alvherre@alvh.no-ip.org>)
	id 1scCh3-0002Up-BC
	for pgsql-bugs@lists.postgresql.org; Thu, 08 Aug 2024 23:37:17 +0000
Received: from fout6-smtp.messagingengine.com ([103.168.172.149])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <alvherre@alvh.no-ip.org>)
	id 1scCh0-003mje-Jr
	for pgsql-bugs@lists.postgresql.org; Thu, 08 Aug 2024 23:37:16 +0000
Received: from compute4.internal (compute4.nyi.internal [10.202.2.44])
	by mailfout.nyi.internal (Postfix) with ESMTP id D1318138809F;
	Thu,  8 Aug 2024 19:37:12 -0400 (EDT)
Received: from mailfrontend2 ([10.202.2.163])
  by compute4.internal (MEProxy); Thu, 08 Aug 2024 19:37:12 -0400
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=1723160232; x=
	1723246632; bh=OU6YVjx1BiARRa9m/CmTb1BPZWw2rU+Bd04duWw4Eww=; b=n
	gDwUChGBKG9S/RUu6bP6LFYXMr2dKYdu+gcpvco6OuOYp5QhdeL5+3XrWy+ozlso
	OBUHhhw7m4QJv/MRbJWtgVcRmHDu8zd52s0VI4r/WsqwcbFn0g8Wss1sFVCWbw4B
	LHQEmvbk7aWUUguBrLQyTKsL45UYuyMjiaeXz1N7nVPVW8eShaOb6VVTcRo/KLvE
	Xvcjcb9XUhCh5HY2NrvoJWtOzqx4uiozSpym/TAqcM6MCTcvGKpCIFisMv6rVBIy
	JjuwusiO1YD7cRqhCUtGEntulFbk9C4a5HO3qX4mlTsiReTpwdpiWG05fN8lTD/E
	FcHkVfUgKDaZH66n/9wSw==
X-ME-Sender: <xms:qFa1ZrPItHkKGwYzWCCfAohy4i0itAfiw7fbEB6yuyS_KOt8GkmZfg>
    <xme:qFa1Zl9iRMX16FtXZqhspuJxfIDvg4VWclg5ZnvcM_JTRyB0Ftp1r2PdjfeQr8OVa
    w1oN6FrEahTpjJKFg>
X-ME-Received: 
 <xmr:qFa1ZqSUc3eRMppuKPi7BTxszrYHfhmQYGWhk1lzJ8j3B_SUs3tRQ5DHappEszt88CNuEYgs3ZQ>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeeftddrleefgddvfecutefuodetggdotefrodftvf
    curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr
    tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnth
    hsucdlqddutddtmdenucfjughrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecu
    hfhrohhmpeetlhhvrghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrd
    hnohdqihhprdhorhhgqeenucggtffrrghtthgvrhhnpedvkedtffduffdtffffheffhfej
    jefhgfeiueeukeejkeffgfdufffhudffffeuveenucffohhmrghinhepvghnthgvrhhprh
    hishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi
    lhhfrhhomheprghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrghdpnhgspghrtg
    hpthhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepvgigtghluhhsihho
    nhesghhmrghilhdrtghomhdprhgtphhtthhopehtnhgurhifrghnghesghhmrghilhdrtg
    homhdprhgtphhtthhopehpghhsqhhlqdgsuhhgsheslhhishhtshdrphhoshhtghhrvghs
    qhhlrdhorhhg
X-ME-Proxy: <xmx:qFa1ZvsN1Tc5f-OZfwG9vxEgkqRkThM9HUzjcMU4-frzd-OQ5m8fPA>
    <xmx:qFa1Zjc67vlkjEkdgiCRUJtBXuB42tCjR4dIZvxFHEhwEAvMvKubqg>
    <xmx:qFa1Zr3PVlBeXaxAQFPOc1MVGluCpgSdxJAVZb_fSulKwNSqxGBdgA>
    <xmx:qFa1Zv_Scw7zgQc3iFQi7uVFrcQhmVIF_EwlcS5QPg4DnVCUOYsq2A>
    <xmx:qFa1Zv6PMJUW6jUZnnyAYzyCa--CIVA9MigTlJXv-Z5HaYyB6d5PY0Za>
Feedback-ID: ia2694551:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu,
 8 Aug 2024 19:37:12 -0400 (EDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org;
	s=schmee; t=1723160230;
	bh=P7cQnNv8WYium8L9/swuwUADS9rujbjEIiPCgY2LdFU=;
	h=Date:From:To:Cc:Subject:In-Reply-To:From;
	b=eeC1aMro16OIQB/IFNYWmJ1uTv1z+t0MQATf/e+OratDk6AuP5r7PC4Wp2rwQvq5W
	 aSXlcejXlv/ii5RKUkpRbyLxmehwjv8am89FZ1g8kwP936ZggfB5X5sGJ9ZoFDxCoF
	 U6UlUfXqEoKKiHUq6DhkrUr0PDVTv/3iehLGs6s2JPmOZq3thUNKSA56XINnc5ZVln
	 prYfgpvpnAr0RdBdPmPabbPwsICfJOFALZxMm/vTrWD+HaysEHxsD2C4YM1cRYRKPQ
	 F/60Ohku3MQaahfZRYHRvvWSV1elyKYbY97bMxNo/04E+dogXn8FShnWv+M3UDov4e
	 +czIJdDCa3yQw==
Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000)
	id 2BA8DD7; Thu,  8 Aug 2024 19:37:10 -0400 (-04)
Date: Thu, 8 Aug 2024 19:37:10 -0400
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Tender Wang <tndrwang@gmail.com>
Cc: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18541: Reattaching a partition referenced by a foreign key
 fails with an error
Message-ID: <202408082337.tymp7w5xol3z@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAHewXNn9osbWTFqoKRz8tHt8xn-vdkiWDanFkekE6-WSV3Ga9Q@mail.gmail.com>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/202408082337.tymp7w5xol3z%40alvherre.pgsql>
Precedence: bulk

On 2024-Aug-08, Tender Wang wrote:

> Thanks for explanation. The attached patch looks good to me.

Thanks for looking!  I have pushed this now.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/