Re: [GENERAL] more select-for-update questions

2007-08-14 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Ed L. wrote: >> I ran a simple select-for-update test on 8.1.2 and was curious as >> to why the semantics are what they are. Specifically, when you >> have multiple select-for-update-limit queries on the same rows, >> why are rows selected by the blo

Re: [GENERAL] more select-for-update questions

2007-08-14 Thread Alvaro Herrera
Ed L. wrote: > I ran a simple select-for-update test on 8.1.2 and was curious as > to why the semantics are what they are. Specifically, when you > have multiple select-for-update-limit queries on the same rows, > why are rows selected by the blocked query before knowing if > some of those row

[GENERAL] more select-for-update questions

2007-08-06 Thread Ed L.
I ran a simple select-for-update test on 8.1.2 and was curious as to why the semantics are what they are. Specifically, when you have multiple select-for-update-limit queries on the same rows, why are rows selected by the blocked query before knowing if some of those rows will be removed/elimi