On Fri, 2004-10-15 at 15:30, Tom Lane wrote:
> Au contraire: every row that gets locked will be returned to the client.
> The gripe at hand is that the number of such rows may be smaller than
> the client wished, because the LIMIT step is applied before we do the
> FOR UPDATE step
Ah, my apologies -- I misunderstood. Clearly not enough coffee this
Sorry for the noise.
In response to
pgsql-bugs by date
|Next:||From: Josh Berkus||Date: 2004-10-15 16:09:47|
|Subject: Re: SELECT FOR UPDATE and LIMIT 1 behave oddly|
|Previous:||From: Tom Lane||Date: 2004-10-15 05:30:16|
|Subject: Re: SELECT FOR UPDATE and LIMIT 1 behave oddly |