Re: MVCC handling of updates - Mailing list pgsql-novice

From Tom Lane
Subject Re: MVCC handling of updates
Date
Msg-id 1675.1126140089@sss.pgh.pa.us
Whole thread Raw
In response to MVCC handling of updates  ("Kevin Crenshaw" <kcrenshaw@viscient.com>)
List pgsql-novice
"Kevin Crenshaw" <kcrenshaw@viscient.com> writes:
> How does MVCC function when two people try to update the same row at the
> same time?

Whoever gets there first will obtain a row lock on the target row,
and the later arrival(s) will block until the first one commits or
aborts.

            regards, tom lane

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Weird SQL Problem
Next
From: Terry Lee Tucker
Date:
Subject: Re: Get a list of columns for a table