Re: Select for update

On Wed, May 26, 2021, 08:20 Yambu <hyambu(at)gmail(dot)com> wrote:

> This update, sorry forgot to include FOR UPDATE part
>
> UPDATE table1 set status_id=13 WHERE id= ( SELECT id FROM table2 where
> status_id=1 LIMIT 1 *FOR UPDATE*) RETURNING id into v_id;
>
> On Wed, May 26, 2021 at 2:27 PM David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>>
>> On Wednesday, May 26, 2021, Yambu <hyambu(at)gmail(dot)com> wrote:
>>
>>> Hello
>>>
>>> May i know if i run the update below if the row select in SELECT FOR
>>> UPDATE will not be available for selection during update?
>>>
>>> UPDATE table1 set status_id=13 WHERE id= ( SELECT id FROM table2 where
>>> status_id=1 LIMIT 1) RETURNING id into v_id;
>>>
>>
>> Which update? The way it works is by locking - Ihe row is available but
>> locked and may require waiting.
>>
>> David J.
>>
>
I don't think there is a point in saying for update when you are executing
an update command.

David J.

>