Re: Transactions in one table
Rob Sargent <[email protected]> Fri, 27 Sep 2019 10:41:05 -0600
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <[email protected]> |
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;