Thanks alot..i have implemented in same format.You people are awesome.Thank You once again
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 Member of Technical Staff Groupon,Chennai
