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