Re: [HACKERS] Re: Constraints and inheritance - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] Re: Constraints and inheritance
Date
Msg-id 353BF3E7.7D1F063F@sable.krasnoyarsk.su
Whole thread Raw
In response to Re: Constraints and inheritance  ("Oliver Elphick" <olly@lfix.co.uk>)
List 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

pgsql-hackers by date:

Previous
From: Hostmaster@phoenixcomm.net
Date:
Subject: subscribe
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Re: [QUESTIONS] Configuration problems in PostgreSQL 6.3.2 on Linux-ELF