Re: [HACKERS] Conflicting constraint being merged

Amit Langote writes: > Currently, if child table has a non-inherited constraint and a constraint > with the same name is added to the parent, it will fail with an error as > illustrated below: > ... > If we had allowed it to be merged, any children of child itself

[HACKERS] Conflicting constraint being merged

Currently, if child table has a non-inherited constraint and a constraint with the same name is added to the parent, it will fail with an error as illustrated below: create table parent (a int); CREATE TABLE create table child (constraint check_a check (a > 0) no inherit) inherits (parent);