But 535 will need to re acquire the row before it can update. Alan On 07/01/2013 11:34 AM, "W O" <sistemas2000profesio...@gmail.com> wrote:
> Hello everybody > > - Transaction 510 inserts a new row > - Transaction 510 commit > - Transaction 526 start > - Transaction 526 updates the row inserted by transaction 510 > - Transaction 535 start > - Transaction 535 wants to update the row inserted by transaction 510 but > unsuccesfully because transaction 526 has locked it > - Transaction 526 commit > > Can now transaction 535 update the row inserted by transaction 510? In this > case, updates makes for transaction 526 will be lost, right? > > Or transaction 535 should first to read the new row commited (the 526) > before making the update? > > Greetings. > > Walter. > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > > [Non-text portions of this message have been removed]