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
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