Re: Foreign keys referencing parent table fails on insert

Поиск
Список
Период
Сортировка
От postgresbugs
Тема Re: Foreign keys referencing parent table fails on insert
Дата
Msg-id 41AF4720.3020503@grifent.com
обсуждение исходный текст
Ответ на Foreign keys referencing parent table fails on insert  (postgresbugs <postgresbugs@grifent.com>)
Ответы Re: Foreign keys referencing parent table fails on insert  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-bugs
On Wed, 1 Dec 2004, Stephan Szabo wrote:

  On Wed, 1 Dec 2004, postgresbugs wrote:



    > Foreign keys referencing parent table fails on insert if the key is in
> the table that inherits the parent table.



Unfortunately, primary keys, unique constraints and foreign keys do not
inherit to children in a meaningful fashion. It's one of the big
deficiencies right now.




Too bad. Table inheritance is pretty meaningless without these
abilities. Anyone working on them? In the meantime, I will go back to
views and updating the underlying tables.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Column names: where, group by, having inconsistent behaviour?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [pgsql-hackers-win32] PLTCL