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