Serializable Isolation and read/write conflict with index and different keys

From: Luca Looz <luca(dot)looz92(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Serializable Isolation and read/write conflict with index and different keys
Date: 2017-08-29 16:28:49
Message-ID: CAHXaXTwZ6YX8wpH0o20OY7MeRMNo-XtsKbVd7j67iCYcKi_rpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to use the serializable isolation but i'm getting read/write
dependencies error even if i have an unique index on the column used and
the transactions are using different keys.
For an example see this gist:
https://gist.github.com/nathanl/f98450014f62dcaf0405394a0955e18e
Is this an expected behavior?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2017-08-29 20:19:53 Re: Unlogged Crash Detection
Previous Message John McKown 2017-08-29 15:30:45 Re: Create Action for psql when NOTIFY Recieved