On 25 Sep, Gaetano Mendola wrote:
> [EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
