Re: Rerefences to derived rows - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Rerefences to derived rows
Date
Msg-id Pine.BSF.4.21.0106221130520.9504-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Rerefences to derived rows  (Bo Lorentsen <bl@netgroup.dk>)
List 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.


pgsql-general by date:

Previous
From: Edwin Grubbs
Date:
Subject: Re: Newbie Inheritance Question
Next
From: Tom Lane
Date:
Subject: Re: Multiple Indexing, performance impact