Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Serializable Isolation and read/write conflict with index anddifferent keys - Mailing list pgsql-general

From Luca Looz
Subject [GENERAL] Serializable Isolation and read/write conflict with index anddifferent keys
Date
Msg-id CAHXaXTwZ6YX8wpH0o20OY7MeRMNo-XtsKbVd7j67iCYcKi_rpw@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Serializable Isolation and read/write conflict withindex and different keys  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-general
Tree view
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:
Is this an expected behavior?

pgsql-general by date:

Previous
From: John McKown
Date:
Subject: Re: [GENERAL] Create Action for psql when NOTIFY Recieved
Next
From: Michael Paquier
Date:
Subject: Re: [GENERAL] Unlogged Crash Detection