Re: Cyclic foreign key dependency & table inheritance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cyclic foreign key dependency & table inheritance
Date: 2003-09-13 23:01:29
Message-ID: 21319.1063494089@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Ribe <scott_ribe(at)killerbytes(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2003-09-13 23:06:58 Re: State of Beta 2
Previous Message Scott Ribe 2003-09-13 22:51:46 Re: how can i use SELECT to find a substring of a