Re: [HACKERS] Re: Constraints and inheritance

Vadim B. Mikheev <vadim@sable.krasnoyarsk.su>

From: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
To: Oliver Elphick <olly@lfix.co.uk>
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-04-21T01:18:31Z
Lists: pgsql-hackers
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