Inheritance and foreign keys

From: Brendan Jurd <blakjak(at)blakjak(dot)sytes(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Inheritance and foreign keys
Date: 2003-12-08 20:16:14
Message-ID: 3FD4DC0E.4080903@blakjak.sytes.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I read on the manual page for Inheritance that:

"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. Thus, in the above example,
specifying that another table's column REFERENCES cities(name) would
allow the other table to contain city names but not capital names. This
deficiency will probably be fixed in some future release."

I have a few projects that could benefit from inherited table structure,
and it's a very cool idea, but this inability of indexes to include
derived tables is a real functionality-killer. It's not "Object
Relational" if the objects can't be related to anything!

If someone could give me an idea of how far away this fix is, I'd be
grateful.

Cheers

BJ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-12-08 20:38:54 Re: Inheritance and foreign keys
Previous Message Patrick Hatcher 2003-12-08 19:45:23 Pg_Dump of schema?