Hi I am locking some rows using select for update(nowait=true) inside a transaction.If server in which code exists crashes,locks will be on rows.Those should be removed manually.I donot want that.I want to keep a timeout for that transaction.Could you please helpme out with a solution for this issue.i did not get a proper solution from internet.
On Tue, Apr 8, 2014 at 8:58 PM, Hannes Erven <han...@erven.at> wrote: > Hi, > > > On 2014-04-08 15:27, Vick Khera wrote: > [...] > > Problem 2: you cannot have a second process skip over locked rows. >> > > > In fact, you can: use "FOR UPDATE NOWAIT" and catch any errors. > > e.g. SELECT * FROM jobqueue WHERE id=? FOR UPDATE NOWAIT > > > > -hannes > -- K.Santhosh Kumar