Re: Transactions in one table

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Transactions in one table
Date: 2019-09-27 16:27:11
Message-ID: CAKFQuwYP0Rfp-ib8K+zfyZ0i-d2rqfqROEd12DSxHGC5Cr1uaw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Sep 27, 2019 at 9:22 AM JORGE MALDONADO <jorgemal1960(at)gmail(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rob Sargent 2019-09-27 16:41:05 Re: Transactions in one table
Previous Message Olivier Gautherot 2019-09-27 16:26:08 Re: Transactions in one table