Re: Rerefences to derived rows

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Bo Lorentsen <bl(at)netgroup(dot)dk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Rerefences to derived rows
Date: 2001-06-22 18:32:44
Message-ID: Pine.BSF.4.21.0106221130520.9504-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Fri, 22 Jun 2001, Bo Lorentsen wrote:

> Hi ...
>
> I have been trying to use the OO features in the PostgreSQL database but
> have some problems regarding references between tables.
>
> Normally it is quite simple to secure the integrity between table rows,
> and PostgreSQL will check if the table id is valid, but if I try to make
> a reference to a parent table, and then make a derived table row from
> this parent, to which I make the reference point to, it complains.

Yes, current the foreing key constraints do not inherit to either
the referencing or referenced tables' children. See past discussion on
lists for more details.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Edwin Grubbs 2001-06-22 18:45:48 web site suggestion
Previous Message Edwin Grubbs 2001-06-22 18:12:49 Re: Newbie Inheritance Question