On Thu, 2004-12-23 at 13:56, Mark wrote: > Hi, > Is it possible to lock row(s) when updating a table, so another call > for update( from different session) will be rejected and to be on > hold until lock get released ?
Generally the update itself will lock the table from other updates until your transaction either commits or rolls back. OR are you looking for something like select for update to lock a row to be used to update another row? ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
