Re: Table inheritance - Mailing list pgsql-novice

From Alan Hodgson
Subject Re: Table inheritance
Date
Msg-id 201003251352.14238@hal.medialogik.com
Whole thread Raw
In response to Table inheritance  (Zdravko Balorda <zdravko.balorda@siix.com>)
Responses Re: Table inheritance  (Zdravko Balorda <zdravko.balorda@siix.com>)
List pgsql-novice
On Wednesday 24 March 2010, Zdravko Balorda <zdravko.balorda@siix.com>
wrote:
> Hi,
> I'm new to inheritance. Does anyone have a good link about it?
>
> I have just finished an application using parent and child tables.
> Tables look a bit strange. :)
>
> Inheritance seems a good replacement for foreign keys. One can
> completely forget about them which simplifies programming.
> 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.

--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."

pgsql-novice by date:

Previous
From: Michael Lush
Date:
Subject: Break in WAL numbering and Warm standby
Next
From: Donn Washburn
Date:
Subject: Getting started