Postgres Pro
Downloads
Home   >   mailing lists

Re: Cyclic foreign key dependency & table inheritance - Mailing list pgsql-general

From Tom Lane
Subject Re: Cyclic foreign key dependency & table inheritance
Date
Msg-id 21319.1063494089@sss.pgh.pa.us
Whole thread Raw
In response to Cyclic foreign key dependency & table inheritance  (Scott Ribe <scott_ribe@killerbytes.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Scott Ribe
Date:
Subject: Re: how can i use SELECT to find a substring of a
Next
From: Lamar Owen
Date:
Subject: Re: State of Beta 2