[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: Transactions in one table
From:       Rob Sargent <robjsargent () gmail ! com>
Date:       2019-09-27 16:41:05
Message-ID: edb1a2bc-97e9-0cae-9496-92baddd5a663 () gmail ! com
[Download RAW message or body]


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;



[prev in list] [next in list] [prev in thread] [next in thread]