From: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Tender Wang <tndrwang@gmail.com>
Cc: Junwang Zhao <zhjwpku@gmail.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Cc: Alexander Lakhin <exclusion@gmail.com>
Cc: Guillaume Lelarge <guillaume@lelarge.info>
Cc: Michael Paquier <michael@paquier.xyz>
Subject: Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails
Date: Wed, 23 Oct 2024 10:01:54 +0200
Message-ID: <20241023100154.661231ca@karst> (raw)
In-Reply-To: <202410221432.3qtqbk2q6o7q@alvherre.pgsql>
References: <20241022162312.63021cc6@karst>
<202410221432.3qtqbk2q6o7q@alvherre.pgsql>
On Tue, 22 Oct 2024 16:32:33 +0200
Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> On 2024-Oct-22, Jehan-Guillaume de Rorthais wrote:
>
> > On Fri, 18 Oct 2024 16:50:59 +0200
> > Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
>
> > > For branch 14, I opted to make it delete the constraints on detach.
> > > This isn't ideal but unless somebody wants to spend a lot more time on
> > > this, it seems the best we can do. Leaving broken constraints around
> > > seems worse.
> >
> > Keep that in mind, and move ahead to the next level: self-FK on partitioned
> > table! ;-)
> >
> > https://www.postgresql.org/message-id/flat/20230707175859.17c91538%40karst#0dc7b8afd8b780899021bbb07...
>
> Yeah. I pushed these patches finally, thanks!
Great! Many thanks Alvaro and Tender for your work on this issue.
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-hackers@postgresql.org
Cc: jgdr@dalibo.com, alvherre@alvh.no-ip.org, tndrwang@gmail.com, zhjwpku@gmail.com, exclusion@gmail.com, guillaume@lelarge.info, michael@paquier.xyz
Subject: Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails
In-Reply-To: <20241023100154.661231ca@karst>
* 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