db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From T E Schmitz <mail...@numerixtechnology.de>
Subject SELECT FOR UPDATE
Date Fri, 23 Apr 2004 15:22:05 GMT
Hello,

Is there any means of doing a SELECT for UPDATE, ie to lock a record in 
a transaction?

I mark every record with a 'LastUpdated' timestamp in order to be able 
to check whether it has been updated in the meantime in another session. 
Before any UPDATE or DELETE I re-read the record and compare timestamps. 
But the record really needs to be locked; otherwise there is still a 
window between the SELECT and the UPDATE during which another session 
could modify or delete it.

Does anyone know how to achieve this through Torque?

-- 


Regards,

Tarlika Elisabeth Schmitz

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message