On 25 Sep, Gaetano Mendola wrote:
> markw@osdl.org wrote:
>
>> 2. SELECT d_next_o_id
>> INTO current_o_id
>> FROM district
>> WHERE d_w_id = 1
>> AND d_id = 8
>>
>> 3. UPDATE district
>> SET d_next_o_id = d_next_o_id + 1
>> WHERE d_w_id = 1
>> AND d_id = 8
>
> I don't know exactly what you are trying to do
> but usualy in cases like this, in order to avoid
> further problem in the commit phase you ought to
> do a SELECT .... FOR UPDATE instead.
That appears to have done the trick. Thanks!
Mark