INSERT INTO ... ON CONFLICT(...) DO UPDATE ...

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

INSERT INTO ... ON CONFLICT(...) DO UPDATE ...

Olivier Mascia
Dear,

Assuming no explicit transaction, do statements like:

        INSERT INTO ... ON CONFLICT(...) DO UPDATE ...

are treated completely within a _single_ implicit transaction?
And is this _single_ implicit transaction of type IMMEDIATE?

—  
Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen,
Olivier Mascia



_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: INSERT INTO ... ON CONFLICT(...) DO UPDATE ...

Richard Hipp-3
On 6/14/19, Olivier Mascia <[hidden email]> wrote:
> Dear,
>
> Assuming no explicit transaction, do statements like:
>
> INSERT INTO ... ON CONFLICT(...) DO UPDATE ...
>
> are treated completely within a _single_ implicit transaction?

Yes

> And is this _single_ implicit transaction of type IMMEDIATE?

Yes.

--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users