Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Yeb Havinga <yebhavinga@gmail.com>
Cc: PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>, "w.p.dijkstra@mgrid.net" <w.p.dijkstra@mgrid.net>
Date: 2010-12-01T14:27:21Z
Lists: pgsql-hackers 
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.

			regards, tom lane