Re: inheritence behavior question .... - Mailing list pgsql-general

On Mon, 25 Mar 2002 tsmets@brutele.be wrote:

>
> I did the following  which sounds illogical to me :
> <snip>
> test=> create table father (col1 integer not null unique);
> NOTICE:  CREATE TABLE/UNIQUE will create implicit index 'father_col1_key'
> for table 'father'
> CREATE
> test=> create table son (col2 integer) inherits (father);
> CREATE

Currently primary keys, unique constraints and foreign keys do not
inherit to child tables.  There's also no current notion of unique
across the inheritance tree build in (you can probably kind of fake it
with an additional table and a bunch of rules, but...)

k