Postgres Pro
Downloads
Home   >   mailing lists

Re: FK's to refer to rows in inheritance child - Mailing list pgsql-hackers

From Tom Lane
Subject Re: FK's to refer to rows in inheritance child
Date
Msg-id 15042.1291213641@sss.pgh.pa.us
Whole thread Raw
In response to FK's to refer to rows in inheritance child  (Yeb Havinga <yebhavinga@gmail.com>)
Responses Re: FK's to refer to rows in inheritance child  (Yeb Havinga <yebhavinga@gmail.com>)
Re: FK's to refer to rows in inheritance child  (Florian Pflug <fgp@phlo.org>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: profiling connection overhead
Next
From: Robert Haas
Date:
Subject: Re: GiST insert algorithm rewrite