markw(at)osdl(dot)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