phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Owen Rees-Hayward <>
Subject UPSERT SELECT Isolation Level
Date Thu, 18 Oct 2018 10:21:30 GMT

We are on Phoenix 4.7, so pre-Atomic Upserts that were introduced in 4.9. I
am trying to determine if there is a way to achieve similar functionality

However, having read the documentation I'm not clear on the isolation-level
that is used when UPSERT SELECTs are executed on the serverside.

Can anyone confirm whether both the SELECT and UPSERT elements are
performed atomically? And also that updates to an individual row are
performed serially?

I'm guessing there is no atomicity otherwise the new Atomic Upserts
wouldn't exist.

Thanks in advance, Owen

Owen Rees-Hayward
07912 876046

View raw message