Re: Question regarding how databases support atomicity

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Friday, May 3, 2024, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Friday, May 3, 2024, Siddharth Jain <siddhsql@xxxxxxxxx> wrote:

On Fri, May 3, 2024 at 8:00 PM Siddharth Jain <siddhsql@xxxxxxxxx> 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.

https://www.postgresql.org/docs/current/tutorial-transactions.html

David J.