Thank you for your comments. Sorry for the late reply.
From: Kirk Wolak Sent: Friday, November 25, 2022 6:12 PM
> My first question is why are you not using "WHERE CURRENT OF" cursor_name?
I thought that cursors are preferred for manipulating large numbers of rows.
So I did not consider using
My first question is why are you not using "WHERE CURRENT OF" cursor_name?
The link to the page follows.
But effectively, you are locking the row and that is the row you want to
update (the current row of the cursor).
I wonder if that addresses the problem...
https://www.postgresql.org/docs/curre
