Say I have a table "task" in a Postgresql database that has an integer
column "total_seconds" which is a total number of seconds one or more
actors (people, worker processes, etc.) spent working on the task. So,
these various actors need to add some value to an existing column.
What is the recommended way to to add to an existing integer column like
this and avoid race condition?
I can see in the past I've used a customer result set:
UPDATE task SET total_seconds = total_seconds + ? WHERE id = ?
but, I also have used SELECT .. FOR UPDATE ( i.e. { for => 'update' } )
in a transaction.
Is there any advantage of one over the other?
--
Bill Moseley
[email protected]
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
