alter table only p1 add constraint p1chk check (ff1 > 0);

alter table p1 add constraint p2chk check (ff1 > 10);

-- conisonly should be true for ONLY constraint

select pc.relname, pgc.conname, pgc.contype, pgc.conislocal, pgc.coninhcount, pgc.conisonly from pg_class as pc inner join pg_constraint as pgc on (pgc.conrelid = pc.oid) where pc.relname = 'p1';

select pc.relname, pgc.conname, pgc.contype, pgc.conislocal, pgc.coninhcount, pgc.conisonly from pg_class as pc inner join pg_constraint as pgc on (pgc.conrelid = pc.oid) where pc.relname = 'p1' order by 1,2;

relname | conname | contype | conislocal | coninhcount | conisonly

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

p1 | p1chk | c | t | 0 | t

altertable only p1 addconstraint p1chkcheck (ff1>0);

altertable p1 addconstraint p2chkcheck (ff1>10);

selectpc.relname,pgc.conname,pgc.contype,pgc.conislocal,pgc.coninhcount,pgc.conisonlyfrom pg_classas pcinner join pg_constraintas pgcon (pgc.conrelid=pc.oid)wherepc.relname='p1';

selectpc.relname,pgc.conname,pgc.contype,pgc.conislocal,pgc.coninhcount,pgc.conisonlyfrom pg_classas pcinner join pg_constraintas pgcon (pgc.conrelid=pc.oid)wherepc.relname='p1'order by1,2;

createtablec1 () inherits (p1);