Thread

Re: [HACKERS] Re: Constraints and inheritance

Vadim B. Mikheev <vadim@sable.krasnoyarsk.su> — 1998-04-21T01:18:31Z

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