phoenix-user mailing list archives

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

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
with UPSERT SELECTs.

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
twitter.com/owen4d

Mime
View raw message