"The search condition of the command (the WHERE clause) is re-evaluated
to see if the updated version of the row still matches the search
condition. If so, the second updater proceeds with its operation,
starting from the updated version of the row."
Hey....that's neat. All this time, I've done an unncessary extra select
to see if the value has changed because of competing processes trying to
work on same row....
Once again...kudos to lists like this one and of course, RTFM.
Jeff
Tom Lane wrote:
>Jeff Amiel <jamiel@istreamimaging.com> writes:
>
>
>>>"the docs say that in case of locked rows the where clause is reevaluated: "
>>>
>>>
>
>
>
>>Is this true?
>>Which docs are you refering to (I could find no mention in the postgres
>>docs).....
>>
>>
>
>Second paragraph in
>http://developer.postgresql.org/docs/postgres/transaction-iso.html#XACT-READ-COMMITTED
>
> regards, tom lane
>
>
>
>
--
Jeff Amiel
Systems/Development Manager
iStream Imaging, an iTeam Company
jamiel@iStreamImaging.com
(262) 796-0925 x1011