Re: BUG #1514: Inheritance and Primary Keys

On Wed, Mar 02, 2005 at 03:23:27PM +0000, Peter Newman wrote:

> So my point is (if it is not clear) that the primary key constraint is not
> enforced through subclass tables. Is this intentional?

It's a documented limitation of the current implementation. Here's
an excerpt from the "Inheritance" section of the "Data Definition"
chapter of the documentation:

A limitation of the inheritance feature is that indexes (including
unique constraints) and foreign key constraints only apply to
single tables, not to their inheritance children.

http://www.postgresql.org/docs/8.0/interactive/ddl-inherit.html

Fixing inheritance limitations is on the developers' TODO list --
it's just a matter of somebody deciding it's important enough to
work on.

http://developer.postgresql.org/todo.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/