"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> A re-sort after locking doesn't really make things all nice and
>> intuitive either.
> Would it make any sense to roll back and generate a
> SERIALIZATION_FAILURE?
If that's what you want then you run the transaction in serializable
mode. The point of doing it in READ COMMITTED mode is that you don't
want such a failure.
regards, tom lane