| From: | Arne Roland <A(dot)Roland(at)index(dot)de> |
|---|---|
| To: | Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com> |
| Cc: | Christophe Courtois <christophe(dot)courtois(at)dalibo(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Detaching a partition with a FK on itself is not possible |
| Date: | 2022-03-21 10:50:46 |
| Message-ID: | 014cd4ec5c6d4e84a3d9a4a6451b722c@index.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Prajna Shetty | 2022-03-21 11:45:05 | Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join |
| Previous Message | Jehan-Guillaume de Rorthais | 2022-03-21 10:36:34 | Re: Detaching a partition with a FK on itself is not possible |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksander Alekseev | 2022-03-21 10:55:44 | Re: [PATCH] Remove workarounds to format [u]int64's |
| Previous Message | Amit Kapila | 2022-03-21 10:38:59 | Re: Column Filtering in Logical Replication |