Re: Detaching a partition with a FK on itself is not possible - Mailing list pgsql-hackers

From Arne Roland
Subject Re: Detaching a partition with a FK on itself is not possible
Date
Msg-id 014cd4ec5c6d4e84a3d9a4a6451b722c@index.de
Whole thread Raw
In response to Re: Detaching a partition with a FK on itself is not possible  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
List pgsql-hackers

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

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Column Filtering in Logical Replication
Next
From: Aleksander Alekseev
Date:
Subject: Re: [PATCH] Remove workarounds to format [u]int64's