Re: foreign key locks, 2nd attempt - Mailing list pgsql-hackers

From Jeroen Vermeulen
Subject Re: foreign key locks, 2nd attempt
Date
Msg-id 4EB63734.1070706@xs4all.nl
Whole thread Raw
In response to foreign key locks, 2nd attempt  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: foreign key locks, 2nd attempt  (Christopher Browne <cbbrowne@gmail.com>)
List pgsql-hackers
On 2011-11-04 01:12, Alvaro Herrera wrote:

> I would like some opinions on the ideas on this patch, and on the patch
> itself.  If someone wants more discussion on implementation details of
> each part of the patch, I'm happy to provide a textual description --
> please just ask.

Jumping in a bit late here, but thanks for working on this: it looks 
like it could solve some annoying problems for us.

I do find myself idly wondering if those problems couldn't be made to go 
away more simply given some kind of “I will never ever update this key” 
constraint.  I'm having trouble picturing the possible lock interactions 
as it is.  :-)


Jeroen


pgsql-hackers by date:

Previous
From: Jeroen Vermeulen
Date:
Subject: Re: Multiple queries in transit
Next
From: Greg Smith
Date:
Subject: Re: [PATCH] optional cleaning queries stored in pg_stat_statements