List *children;

List *newconstrs = NIL;

ListCell *lc;

IndexStmt *stmt;

IndexStmt *indexstmt;

/* No work if not creating a primary key */

if (!IsA(cmd->def, IndexStmt))

return;

indexstmt = castNode(IndexStmt, cmd->def);

if (!indexstmt->primary)

return;

/* No work if no legacy inheritance children are present */

if (rel->rd_rel->relkind != RELKIND_RELATION ||

children = find_inheritance_children(RelationGetRelid(rel), lockmode);

stmt = castNode(IndexStmt, cmd->def);

foreach(lc, stmt->indexParams)

foreach(lc, indexstmt->indexParams)

{

IndexElem *elem = lfirst_node(IndexElem, lc);

Constraint *nnconstr;

ERROR: column "a" in child table must be marked NOT NULL

alter table inh_child alter a set not null;

alter table inh_child inherit inh_parent;-- now it works

drop table inh_parent, inh_child;

-- don't interfere with other types of constraints

alter table inh_parent add constraint inh_parent_excl exclude ((1) with =);

alter table inh_parent add constraint inh_parent_uq unique (a);

alter table inh_parent add constraint inh_parent_fk foreign key (a) references inh_parent (a);

create table inh_child2 () inherits (inh_parent);

create table inh_child3 (like inh_parent);

alter table inh_child3 inherit inh_parent;

select conrelid::regclass, conname, contype, coninhcount, conislocal

from pg_constraint

where conrelid::regclass::text in ('inh_parent', 'inh_child', 'inh_child2', 'inh_child3')

order by 2, 1;

conrelid | conname | contype | coninhcount | conislocal

------------+-----------------------+---------+-------------+------------

inh_child2 | inh_child2_a_not_null | n | 1 | f

inh_child3 | inh_child3_a_not_null | n | 1 | t

inh_child | inh_child_a_not_null | n | 1 | t

inh_child | inh_child_pkey | p | 0 | t

inh_parent | inh_parent_excl | x | 0 | t

inh_parent | inh_parent_fk | f | 0 | t

inh_parent | inh_parent_pkey | p | 0 | t

inh_parent | inh_parent_uq | u | 0 | t

(8 rows)

drop table inh_parent, inh_child, inh_child2, inh_child3;

--

-- test multi inheritance tree

--

altertable inh_child inherit inh_parent;-- nope

altertable inh_child alter asetnot null;

altertable inh_child inherit inh_parent;-- now it works

droptable inh_parent, inh_child;

altertable inh_parent addconstraint inh_parent_excl exclude ((1) with=);

altertable inh_parent addconstraint inh_parent_uq unique (a);

altertable inh_parent addconstraint inh_parent_fkforeign key (a)references inh_parent (a);

createtableinh_child2 () inherits (inh_parent);

createtableinh_child3 (like inh_parent);

altertable inh_child3 inherit inh_parent;

select conrelid::regclass, conname, contype, coninhcount, conislocal

from pg_constraint

where conrelid::regclass::textin ('inh_parent','inh_child','inh_child2','inh_child3')

order by2,1;

droptable inh_parent, inh_child, inh_child2, inh_child3;