Re: Transactions in one table

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: Transactions in one table
Date: 2019-09-27 16:41:05
Message-ID: edb1a2bc-97e9-0cae-9496-92baddd5a663@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On 9/27/19 10:21 AM, JORGE MALDONADO 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.
>
> Best regards,
> Jorge Maldonado

When making changes interactively I highly recommend begin; <sql>; like
the number of affected rows; commit;

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Pepe TD Vo 2019-10-04 13:26:52 Automatically updating a new information column in PostgreSQL
Previous Message David G. Johnston 2019-09-27 16:27:11 Re: Transactions in one table