Re: foreign keys with inherited tables

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: foreign keys with inherited tables
Дата
Msg-id Pine.BSF.4.21.0104161402460.72603-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на foreign keys with inherited tables  (Matt Magoffin <mmagoffin@proxicom.com>)
Список pgsql-general
On Mon, 16 Apr 2001, Matt Magoffin wrote:

> This results in this error on the last INSERT statement:
>
> ERROR:  foo_id_constraint referential integrity violation - key
> referenced from foobar not found in foo
>
> which I assume is because the foo(id = 2) object is actually in the bar
> table? Is there another way to get this foreign check to work?
>

Not currently in that form using the foreign key constraints.  Hopefully
for 7.2.

I believe a work around using a separate key table was post about a month
ago or so.



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

Предыдущее
От: Matt Magoffin
Дата:
Сообщение: foreign keys with inherited tables
Следующее
От: Joseph Shraibman
Дата:
Сообщение: 7.0.3 ==> 7.1