Re: Question regarding how databases support atomicity - Mailing list pgsql-general

From David G. Johnston
Subject Re: Question regarding how databases support atomicity
Date
Msg-id CAKFQuwbSYnTbWtXqMCbOYtEec1ot28Bjvyx+MsqW-USw4mOu_w@mail.gmail.com
Whole thread Raw
In response to Re: Question regarding how databases support atomicity  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
On Friday, May 3, 2024, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Friday, May 3, 2024, Siddharth Jain <siddhsql@gmail.com> wrote:


On Fri, May 3, 2024 at 8:00 PM Siddharth Jain <siddhsql@gmail.com> wrote:


The way I understand this is that if there is a failure in-between, we start undoing and reverting the previous operations one by one.

You need to ensure a “begin” happens before Step 1 and a “commit” after Step 3.

As described in our documentation.


David J.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Question regarding how databases support atomicity
Next
From: Christophe Pettus
Date:
Subject: Re: Question regarding how databases support atomicity