Re: Integrity and Inheritance - Mailing list pgsql-sql

From Tom Lane
Subject Re: Integrity and Inheritance
Date
Msg-id 20987.992189479@sss.pgh.pa.us
Whole thread Raw
In response to Re: Integrity and Inheritance  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Integrity and Inheritance
List pgsql-sql
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> One problem is that for update isn't supported across inheritance trees
> AFAICS and the triggers use for update for the appropriate locking.

It's possible (maybe even likely) that this could be fixed with minimal
work.  I punted on it for 7.1 due to lack of time.  However, is that
really the major obstacle in the way of inherited foreign keys?  Seems
like there are a bunch of issues that'd require cross-table unique
indexes, as well.
        regards, tom lane


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Integrity and Inheritance
Next
From: Stephan Szabo
Date:
Subject: Re: Integrity and Inheritance