Horton

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

Yeb Havinga <yebhavinga@gmail.com>

View thread
From: Yeb Havinga <yebhavinga@gmail.com>
To: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Andrew Dunstan <andrew@dunslane.net>, Greg Stark <gsstark@mit.edu>, PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>, "w.p.dijkstra@mgrid.net" <w.p.dijkstra@mgrid.net>
Date: 2010-12-04T19:08:20Z
Lists: pgsql-hackers 
On 2010-12-04 19:22, Dimitri Fontaine wrote:
>
> That's calling for a try :)
>
> What about a new index type that follows the partitioning scheme in its
> root pages in a way that allow the locking to occur in a subpart of it,
> rather than for the whole index.
Would that (global) index be totally ordered? That seems a prerequisite 
for unique constraint checking with _bt_doinsert.

regards,
Yeb Havinga