Recursion to child tables is incorrectly trying to locate the constraint by name:
create table notnull_tbl1 (a int); alter table notnull_tbl1 add constraint foo not null a not valid; create table notnull_chld (a int); alter table notnull_chld add constraint blah not null a not valid; alter table notnull_chld inherit notnull_tbl1 ; -- this fails but shouldn't: alter table notnull_tbl1 validate constraint foo; ERROR: constraint "foo" of relation "notnull_chld" does not exist The end result here should be that the constraint `blah` in table notnull_chld is marked as validated. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ Syntax error: function hell() needs an argument. Please choose what hell you want to involve.
