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

From David G. Johnston
Subject Re: Transactions in one table
Date
Msg-id CAKFQuwYP0Rfp-ib8K+zfyZ0i-d2rqfqROEd12DSxHGC5Cr1uaw@mail.gmail.com
Whole thread Raw
In response to Transactions in one table  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-sql
On Fri, Sep 27, 2019 at 9:22 AM JORGE MALDONADO <jorgemal1960@gmail.com> wrote:
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.

Its not necessary to explicitly issue a begin/commit but it also isn't something to actively avoid.

Dave

pgsql-sql by date:

Previous
From: Olivier Gautherot
Date:
Subject: Re: Transactions in one table
Next
From: Rob Sargent
Date:
Subject: Re: Transactions in one table