Hey, wonderful software, but i am trying to define do you have a FOR UPDATE support.
It can be very handy to do such things when you have very concurrent selects & updates, and you wanna make sure only one worker/instance will work with record concurrently.
In e.g. if i want to load use and check if it have a proper status i will do:
BEGIN;
SELECT * FROM user WHERE id=123 FOR UPDATE SKIP LOCKED;
... DOING SOME STUFF, checking if it return nothing and e.t.c
Hey, wonderful software, but i am trying to define do you have a
FOR UPDATEsupport.It can be very handy to do such things when you have very concurrent selects & updates, and you wanna make sure only one worker/instance will work with record concurrently.
In e.g. if i want to load use and check if it have a proper
statusi will do:... DOING SOME STUFF, checking if it return nothing and e.t.c
COMMIT;