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 24510.1291483199@sss.pgh.pa.us
Whole thread Raw
In response to Re: FK's to refer to rows in inheritance child  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: FK's to refer to rows in inheritance child  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Re: FK's to refer to rows in inheritance child  (David Fetter <david@fetter.org>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Those are difficulties, certainly. Are they insurmountable obstacles, 
> though? This is something that has been on the TODO list for ages and I 
> think is very worth doing, if we can.

They're possibly surmountable with enough effort, though I think in
reality what you'd end up with is annoying corner-case behaviors
(eg, deadlock failures in some cases).  Anyway Greg and I seem to
agree on the bottom line: such a feature is not actually interesting
for partitioned tables, as it destroys most of the benefits of
partitioning.  I have a feeling that the feature will languish on the
TODO list forever, unless someone comes up with a brilliant idea to
avoid the problems.  As is, the return on investment to do it just
isn't there.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: FK's to refer to rows in inheritance child
Next
From: Oleg Bartunov
Date:
Subject: Re: knngist - 0.8