Re: foreign keys for array/period contains relationships

On Mon, 2010-10-25 at 12:34 -0700, Greg Stark wrote:
> On Mon, Oct 25, 2010 at 12:11 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
> > Is this sort of thing feasible?  Has anyone done more research into the
> > necessary details?
> 
> I think the problems arise when you try to figure out what records you
> need to lock to prevent someone from deleting the referenced rows
> before you commit.

I think that's easier when the PK must contain the FK, because then you
only need to lock one record. Even when you need to lock multiple
records, it seems feasible, and is just an index lookup, right? Do you
see a particular problem?

Regards,Jeff Davis