Z M, May 24, 2017 - 3:18 pm UTC
Thanks for the answer. I might have not written it completely clearly, but I want to add ON DELETE CASCADE to an existing table. I am not creating a new table, I am trying to modify an existing one. Hence my proposed solution of recreating the original constraint, rather than changing the original constraint in CREATE TABLE statement.
May 25, 2017 - 1:30 am UTC
Yes, that is a restriction of reference partitioning. Moreover, there is almost nothing you can do with the child table in terms of temporarily or permanently disassociating it with the parent without actually dropping the child.
So you'd be heading for a maintenance activity here.
A reader, February 12, 2019 - 3:28 am UTC
February 12, 2019 - 10:50 am UTC
That refers to dropping the whole parent partition. Using an on delete cascade FK allows you to delete a single row from the parent partition. And remove the child row automagically.