Re: [GENERAL] MVCC and insert

2005-05-03 Thread Alvaro Herrera
On Tue, May 03, 2005 at 12:28:05PM -0400, Allen wrote: > Hows does MVCC handle two concurrent tasks trying to insert the same > row? Example pseudo-code: > > > select row from table where... > > if not found, > > prepare row > > insert row > > else > > update row > > ... continue processing

[GENERAL] MVCC and insert

2005-05-03 Thread Allen
Hows does MVCC handle two concurrent tasks trying to insert the same row? Example pseudo-code: > select row from table where... > if not found, > prepare row > insert row > else > update row > ... continue processing what happens if TASK1 inserts the row first, and continues processing (no