Skip site navigation (1) Skip section navigation (2)

Re: index not used with inherited tables

From: Verena Ruff <lists(at)triosolutions(dot)at>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>, pgsql-novice(at)postgresql(dot)org
Subject: Re: index not used with inherited tables
Date: 2006-05-12 12:35:34
Message-ID: 44648116.6020908@triosolutions.at (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-05-12 14:11:53
Subject: Re: index not used with inherited tables
Previous:From: Steve TucknottDate: 2006-05-11 18:39:33
Subject: Re: Dev DB Structure Updates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group