Re: Cyclic foreign key dependency & table inheritance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cyclic foreign key dependency & table inheritance
Дата
Msg-id 21319.1063494089@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Cyclic foreign key dependency & table inheritance  (Scott Ribe <scott_ribe@killerbytes.com>)
Список pgsql-general
Scott Ribe <scott_ribe@killerbytes.com> writes:
> I've got a problem which I think may be a bug in Postgres, but I wonder if
> I'm missing something. Two tables, A & B have foreign key relations to each
> other. A 3rd table C, inherits from A.

C will not participate in the foreign key relationship.  This is a
well-known shortcoming of the inheritance mechanism.  It may get fixed
some day, but don't hold your breath ...

            regards, tom lane

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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: how can i use SELECT to find a substring of a
Следующее
От: Lamar Owen
Дата:
Сообщение: Re: State of Beta 2