| From: | Arne Roland <A(dot)Roland(at)index(dot)de> |
|---|---|
| To: | Christophe Courtois <christophe(dot)courtois(at)dalibo(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Detaching a partition with a FK on itself is not possible |
| Date: | 2022-03-17 17:58:04 |
| Message-ID: | 666ad9554f9d4781aa45c4613544075d@index.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Hi,
I don't think this a bug, but a feature request. I therefore think hackers would be more appropriate.
I don't see how an additional syntax to modify the constraint should help.
If I'd want to fix this, I'd try to teach the detach partition code about self referencing foreign keys. It seems to me like that would be the cleanest solution, because the user doesn't need to care about this at all.
I don't think, I'll spend time on this in the near future though.
Regards
Arne
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2022-03-18 12:27:58 | Re: Logical replication stops dropping used initial-sync replication slots |
| Previous Message | Christophe Courtois | 2022-03-17 17:31:37 | Detaching a partition with a FK on itself is not possible |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2022-03-17 18:03:31 | Re: Proposal: Support custom authentication methods using hooks |
| Previous Message | Christophe Courtois | 2022-03-17 17:31:37 | Detaching a partition with a FK on itself is not possible |