Postgres Pro
Downloads
Home   >   mailing lists

Re: Transactions in one table - Mailing list pgsql-sql

From Olivier Gautherot
Subject Re: Transactions in one table
Date
Msg-id CAJ7S9TWc=g81qEO43Cxa0DnXg35WzSZZpgdcqRKHojPkO1SkFw@mail.gmail.com
Whole thread Raw
In response to Transactions in one table  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-sql
Tree view
Hi Jorge,

On Fri, Sep 27, 2019 at 1:22 PM JORGE MALDONADO <jorgemal1960@gmail.com> wrote:
Hi,

Does it make any sense to use transactions if only one DB operation is performed in only one table?
For example, insert only one record in a "countries" table without doing anything else in other table(s). One operation, one table, that´s it.
 
If it works, it will perform automatically a COMMIT. If it fails, it will perform a ROLLBACK. You don't gain much with atomic operations.


pgsql-sql by date:

Previous
From: JORGE MALDONADO
Date:
Subject: Transactions in one table
Next
From: "David G. Johnston"
Date:
Subject: Re: Transactions in one table