Re: Django Upsert Transaction

2017-08-29 Thread James Schneider
On Aug 25, 2017 5:45 AM, "Fendy Purnomo" wrote: Hi, I'm relatively new to Django and have use it in past few months. Recently I stumbled upon a SQL deadlock. After digging deeper it was caused by SQL gap lock when inserting. I'm assuming this was not in a Django app?

Re: Django Upsert Transaction

2017-08-25 Thread Mike Morris
what's the point of doing this I assume it is "atomicity" -- making sure the update/insert pair is indivisible and that it is impossible to do one without the other. Depending on application, that could be catastrophic... On 08/25/2017 04:39 AM, Fendy Purnomo wrote: Hi, I'm

Django Upsert Transaction

2017-08-25 Thread Fendy Purnomo
Hi, I'm relatively new to Django and have use it in past few months. Recently I stumbled upon a SQL deadlock. After digging deeper it was caused by SQL gap lock when inserting. Then I found that Django upsert is actually putting update/insert inside one transaction. I might be missing what's