Re: index not used with inherited tables - Mailing list pgsql-novice

Hi,

Sean Davis schrieb:
>> one of these child tables is mitarbeiter:
>> CREATE TABLE mitarbeiter
>> (
>>   -- some fields --
>>   CONSTRAINT pers_id_pk_mitarbeiter PRIMARY KEY (pers_id)
>> ) INHERITS (person)
>>
> Hi, Verena.  See here:
>
> http://www.postgresql.org/docs/8.1/interactive/ut ddl-inherit.html
>
> Notice the "Caveats" section at the bottom.  Indexes are not inherited
But I define a new primary key constraint in the child table, using the
column frm the parent. Shouldn't create this an index implicitly?

Regards,
Verena