Re: foreign keys with inherited tables - Mailing list pgsql-general

From Stephan Szabo
Subject Re: foreign keys with inherited tables
Date
Msg-id Pine.BSF.4.21.0104161402460.72603-100000@megazone23.bigpanda.com
Whole thread Raw
In response to foreign keys with inherited tables  (Matt Magoffin <mmagoffin@proxicom.com>)
List 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 by date:

Previous
From: Matt Magoffin
Date:
Subject: foreign keys with inherited tables
Next
From: Joseph Shraibman
Date:
Subject: 7.0.3 ==> 7.1