Re: [HACKERS] Re: Constraints and inheritance

Oliver Elphick wrote:
>
> I am thinking only of check constraints, at the moment.  As I said above,
> I think that the primary key should apply to all descendants, using the same
> index.  I am not sure about foreign keys, NOT NULL and UNIQUE.

This can be done: we could store table' oid in btree index items
and keep index items for all tables in one index.

Vadim