Re: Serializable Isolation Level

On Wednesday, May 24, 2017, Fran G <poupou1980(at)gmail(dot)com> wrote:

> David, Thanks for the quick response.
> I do have a primary key defined. But my table itself has just 256 rows. I
> suspect for this small a size, postgres might have grouped several ids
> together which could cause this issue. The underlying concept which I
> gather from your post, is that postgres is keeping track of not only the
> data being accessed for modification, but also the path to access it. While
> my observations do support this, I never came across documentation which
> state this explicitly. Have I understood the problem right?
>

https://www.postgresql.org/docs/9.6/static/transaction-iso.html#XACT-SERIALIZABLE

The last bullet seems apropos.

David J.