Re: Question: update and transaction isolation - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Question: update and transaction isolation
Date
Msg-id Pine.LNX.4.30.0204031708050.684-100000@peter.localdomain
Whole thread Raw
In response to Re: Question: update and transaction isolation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Question: update and transaction isolation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane writes:

> The reason it works in read-committed mode is that the second guy to
> arrive at the row will observe that the row has an update in progress;
> will block waiting for the previous updater to commit or abort; and if
> commit, will use the updated version of the row as the starting point
> for his update.  (This is what the EvalPlanQual ugliness in the executor
> is all about.)

Isn't that a violation of the principle that transactions in read
committed mode will look at the data that was committed *before* the
statement had begun?

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Martin Renters
Date:
Subject: Re: Suggestions please: names for function cachability
Next
From: Peter Eisentraut
Date:
Subject: Re: Locale support is now on by default