"Kevin Grittner" <[email protected]> writes:
> Tom Lane <[email protected]> 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
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers