Message-ID: <4fe75dda-d8cc-1763-9741-e1efdaed33d4@gmail.com>
Date: Tue, 24 Sep 2024 15:00:01 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: BUG #18628: Race condition during attach/detach partition breaks
 constraints of partition having foreign key
Content-Language: en-US
To: Alvaro Herrera <alvherre@alvh.no-ip.org>, tender wang <tndrwang@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
References: <202409241123.dnrn6pdmoud6@alvherre.pgsql>
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: <202409241123.dnrn6pdmoud6@alvherre.pgsql>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/4fe75dda-d8cc-1763-9741-e1efdaed33d4%40gmail.com>
Precedence: bulk

24.09.2024 14:23, Alvaro Herrera wrote:
> I suspect this is the same problem that was reported by Jehan-Guillaume
> de Rorthais, for which there are two patches proposed, his and mine:
>
> [1] https://postgr.es/m/202408072250.2c4fkhwf56lk@alvherre.pgsql
> [2] https://postgr.es/m/20240905005728.0836d609@karst
>
> I haven't looked at his patch, but I suspect it's better than mine on
> maintainability grounds.  I think his code causes more catalog churn,
> though perhaps we don't care too much about that in this particular

Yes, v2-0001-Rework-foreign-key-....patch works for me — the partition
detached with no error.

Sorry for the noise again.

Best regards,
Alexander