Unanswered: Lock and Unlock a row in a transaction
Well, my problem seems a little confusing. I need to lock a table row while I am in a transaction, then I have to unlock it but I still want to be in transaction. Maybe it must be a nested transaction or sth ?
The main problem in here, when I want to unlock the row, I need to use COMMIT so my transaction ended before i preffered. I'm not sure if I make myself clear enough but still hoping to get some ideas...