Inheritance and foreign keys
От | Brendan Jurd |
---|---|
Тема | Inheritance and foreign keys |
Дата | |
Msg-id | 3FD4DC0E.4080903@blakjak.sytes.net обсуждение исходный текст |
Ответы |
Re: Inheritance and foreign keys
Re: Inheritance and foreign keys |
Список | 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
В списке pgsql-general по дате отправления: