Inherited tables and foreign keys

Поиск
Список
Период
Сортировка
От Eva Hovelsrød
Тема Inherited tables and foreign keys
Дата
Msg-id 200403041517.35555.ehovelsrod@itsopen.net
обсуждение исходный текст
Список pgsql-general
Hi, I just realized that foreign keys to an inherited table don't work when
the record was inserted into a child table. That is postgresql-7.3.2-3.

Does anyone know whether anyone is working on that area or if there are any
plans to?

Or is there a simple workaround, like in the foreign key definition to say
that a column should reference the parent table OR the child table (i.e.,
providing a list of tables to look for references in)?

Best regards,

Eva Hovelsrod

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

Предыдущее
От: "Karl O. Pinc"
Дата:
Сообщение: Re: REFERENCES error message complaint, suggestion
Следующее
От: "Karl O. Pinc"
Дата:
Сообщение: Re: Moving from MySQL to PGSQL....some questions (multilevel