Re: Table inheritance

From: Zdravko Balorda <zdravko(dot)balorda(at)siix(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Table inheritance
Date: 2010-03-26 10:25:13
Message-ID: hoi228$2tl5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


>> A great idea, this inheritance.
>
> It ... doesn't. In fact, it makes them harder, as you need to create them
> and associated indexes on each child table.

Hmm ... But:

SELECT parent_field FROM child_table WHERE child_field = 'something';
does the job. For this one needs foreign key, but if child_table inherits
from parent_table it works without it.

Am I wrong?

Zdravko

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mladen Gogala 2010-03-26 15:15:39 Re: Table inheritance
Previous Message Łukasz Dejneka 2010-03-26 08:15:50 Re: Using HStore type in TSearch