Re: out-of-order caution - Mailing list pgsql-hackers

From Tom Lane
Subject Re: out-of-order caution
Date
Msg-id 4459.1319744422@sss.pgh.pa.us
Whole thread Raw
In response to Re: out-of-order caution  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> (2)  They *can* get a serialization failure involving just two
> transactions: a read and a write.

Only if you ignore the difference between SELECT FOR UPDATE/SHARE and
plain SELECT.  I think calling the former a "read" is a conceptual error
to start with.  It has the same locking and synchronization behavior as
a write.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: out-of-order caution
Next
From: fschmidt
Date:
Subject: portal with hold