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
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? |