From: Arne Roland <A.Roland@index.de>
To: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Cc: Christophe Courtois <christophe.courtois@dalibo.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Detaching a partition with a FK on itself is not possible
Date: Mon, 21 Mar 2022 10:50:46 +0000
Message-ID: <014cd4ec5c6d4e84a3d9a4a6451b722c@index.de> (raw)
In-Reply-To: <20220321113634.68c09d4b@karst>
References: <06c75996-f72b-e57b-0efe-31e74a475c39@dalibo.com>
<20220321113634.68c09d4b@karst>
From: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Sent: Monday, March 21, 2022 11:36
Subject: Re: Detaching a partition with a FK on itself is not possible
> I changed the list destination
Thanks
> Another solution could be to teach the create partition to detect a self
> referencing FK and actually create a self referencing FK, not pointing to the
> partitioned table, and of course issuing a NOTICE to the client.
That's what I meant. I didn't think about the NOTICE, but that's a good idea.
Regards
Arne
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: A.Roland@index.de, jgdr@dalibo.com, christophe.courtois@dalibo.com, pgsql-hackers@postgresql.org
Subject: Re: Detaching a partition with a FK on itself is not possible
In-Reply-To: <014cd4ec5c6d4e84a3d9a4a6451b722c@index.de>
* 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