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

Yeb Havinga <yebhavinga@gmail.com>

From: Yeb Havinga <yebhavinga@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>, "w.p.dijkstra@mgrid.net" <w.p.dijkstra@mgrid.net>
Date: 2010-12-01T14:51:12Z
Lists: pgsql-hackers
On 2010-12-01 15:27, Tom Lane wrote:
> Yeb Havinga<yebhavinga@gmail.com>  writes:
>> 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)
>> Though it passes simple tests, it is far from complete.
> Indeed.  This isn't even worth the time to review, unless you have a
> proposal for fixing the unique-index-across-multiple-tables problem.
That was in the part that you chose to not quote.

regards,
Yeb Havinga