However there is a problem: I can not use a "single-instance" cronjob to run words_expire_games hourly.
Setup a cron job that invokes the servlet - probably via "curl"
My question is if I should ensure that only 1 servlet runs the custom PL/pgSQL function by using "synchronized" in Java as I do it right now:
Probably not. UPDATE takes out a lock that will prevent other updates from acting on the same records concurrently.
Or if maybe there is some condition (maybe "UPDATE SKIP LOCKED"?) I could add to my custom function copy-pasted below? -
Why are you trying random syntax that isn't documented?
UPDATE words_games
SET finished = CURRENT_TIMESTAMP
WHERE finished IS NULL
That should be sufficient. Do you have any examples that show it is not?
In short, one of the main reasons for "UPDATE RETURNING" is so that one needn't determine the records to be updated separately from the actual act of updating. Instead you update first and then capture the results for subsequent use.
David J.
