I need only one process to change the "state" of a row. This is with Postgresql. UPDATE foo SET state = 'processing' WHERE id = <foo id> state = 'ready' Are there times when that might not be atomic? Is it possible more than one process could run that update and be told that 1 row was updated? Thanks, -- Bill Moseley moseley at hank.org