Re: Integrity and Inheritance

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