Skip to content
Snippets Groups Projects
  • Robert Haas's avatar
    31b6fc06
    Fix inheritance count tracking in ALTER TABLE .. ADD CONSTRAINT. · 31b6fc06
    Robert Haas authored
    Without this patch, constraints inherited by children of a parent
    table which itself has multiple inheritance parents can end up with
    the wrong coninhcount.  After dropping the constraint, the children
    end up with a leftover copy of the constraint that is not dumped
    and cannot be dropped.  There is a similar problem with ALTER TABLE
    .. ADD COLUMN, but that looks significantly more difficult to
    resolve, so I'm committing this fix separately.
    
    Back-patch to 8.4, which is the first release that has coninhcount.
    
    Report by Hank Enting.
    31b6fc06
    History
    Fix inheritance count tracking in ALTER TABLE .. ADD CONSTRAINT.
    Robert Haas authored
    Without this patch, constraints inherited by children of a parent
    table which itself has multiple inheritance parents can end up with
    the wrong coninhcount.  After dropping the constraint, the children
    end up with a leftover copy of the constraint that is not dumped
    and cannot be dropped.  There is a similar problem with ALTER TABLE
    .. ADD COLUMN, but that looks significantly more difficult to
    resolve, so I'm committing this fix separately.
    
    Back-patch to 8.4, which is the first release that has coninhcount.
    
    Report by Hank Enting.