Re: REFERENCES and INHERITS restrictions?

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: REFERENCES and INHERITS restrictions?
Дата
Msg-id 87pruifqbo.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на REFERENCES and INHERITS restrictions?  ("Stefan Scheidegger" <Stefan.Scheidegger@gmx.net>)
Список pgsql-sql
"Stefan Scheidegger" <Stefan.Scheidegger@gmx.net> writes:

> Why is this not possible? It seems that this is about inheritance. When I
> reference directly to tbl_child1, everything works just fine.

I'm afraid inheritance doesn't work with foreign key references. You can have
references to specific tables but they don't include any child tables. A
related limitation is that you can't enforce unique constraints across tables
and their children.

Solving this doesn't seem to be high on anyone's priority list. If anything
what interests more people is using inheritance for partitioning support.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!


В списке pgsql-sql по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: how do I get table DDL from psql (not from pg_dump)
Следующее
От: Frank Bax
Дата:
Сообщение: Re: how do I get table DDL from psql (not from pg_dump)