Re: FK's to refer to rows in inheritance child

On Wed, 2010-12-01 at 15:07 +0100, Yeb Havinga wrote:

> FK's cannot refer to rows in inheritance childs. With some changes in 
> LockRows, together with removing the ONLY keyword in ri_trigger.c, it 
> was possible to refer to the rows in child relations. (WIP patch attached)

This has a userspace solution, which seems preferable technically.

Just have an Object table that is referred to by all parts of the
hierarchy, maintained by triggers. With PK.

CASCADE doesn't work, but then that was an open issue there anyway.

-- Simon Riggs           http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services