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

From Rob Sargent
Subject Re: Transactions in one table
Date
Msg-id edb1a2bc-97e9-0cae-9496-92baddd5a663@gmail.com
Whole thread Raw
In response to Transactions in one table  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List 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;




pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Transactions in one table
Next
From: "Voillequin, Jean-Marc"
Date:
Subject: RE: Automatically updating a new information column in PostgreSQL