From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Alexander Lakhin <exclusion@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18628: Race condition during attach/detach partition breaks constraints of partition having foreign key
Date: Tue, 24 Sep 2024 13:23:33 +0200
Message-ID: <202409241123.dnrn6pdmoud6@alvherre.pgsql> (raw)
In-Reply-To: <2db29417-eac1-35b6-94e3-a9c0bdb9c035@gmail.com>
On 2024-Sep-24, Alexander Lakhin wrote:
> I'm sorry, I' was too hasty to untangle those queries. Now I see that
> this error can be produced with this serial script:
> [...]
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
case.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alvherre@alvh.no-ip.org, exclusion@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18628: Race condition during attach/detach partition breaks constraints of partition having foreign key
In-Reply-To: <202409241123.dnrn6pdmoud6@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox