Skip to main content

ban-detach-inheritance

problem​

DETACH PARTITION and NO INHERIT change which rows existing clients access through a parent table. This rule is opt-in. An unconditional CREATE earlier in the file suppresses a warning for that new object.

alter table parent detach partition child concurrently;

solution​

Update clients that use the parent table before detaching the child.

Enable this rule with --include ban-detach-inheritance.