Postgres Pro
Downloads
Home   >   mailing lists

Re: outer joins and for update - Mailing list pgsql-hackers

From Tom Lane
Subject Re: outer joins and for update
Date
Msg-id 11392.1131982369@sss.pgh.pa.us
Whole thread Raw
In response to Re: outer joins and for update  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
Tree view 
Gavin Sherry <swm@linuxworld.com.au> writes:
> On Mon, 14 Nov 2005, Tom Lane wrote:
>> The point of the comment really is that this is a predicate locking
>> problem.

> I thought you might say that. I'm yet to do much reading on predicate
> locking -- do you think it is an area we will even pursue?

Don't hold your breath ;-) ... AFAICS it's a hard problem and would have
horrid repercussions for performance.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Should a plan node's result tuple slot be read-only to caller?
Next
From: Chris Browne
Date:
Subject: Re: PostgreSQL roadmap for 8.2 and beyond