Hi!
I am implementing a queue using PostgreSQL.
I am of course using "FOR UPDATE SKIP LOCKED".
Is there any way I can tell PostgreSQL to only "operate" on the locked row, and/or a way to reference it?
Some explanations of what I mean:
- I have a table with N rows
- I lock row X with a PG Function, in transaction 1
- I do something in my code, using transaction 2
- I update the status of row X with a PG Function, in transaction 1
In last step, I update the row X status, passing my function the ID of this row X.
But, nothing stops me from updating row Y in the queue table, for whatever reason.
My question again: any way to force a "Just update the row X you locked before, and nothing else/more?"
Thanks!