Re: Is this a commit problem? - Mailing list pgsql-hackers

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