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/
