Re: Is this a commit problem?

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.


Regards
Gaeatano Mendola