| From: | Olivier Gautherot <ogautherot(at)gautherot(dot)net> |
|---|---|
| To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Transactions in one table |
| Date: | 2019-09-27 16:26:08 |
| Message-ID: | CAJ7S9TWc=g81qEO43Cxa0DnXg35WzSZZpgdcqRKHojPkO1SkFw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi Jorge,
On Fri, Sep 27, 2019 at 1:22 PM JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
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.
>
If it works, it will perform automatically a COMMIT. If it fails, it will
perform a ROLLBACK. You don't gain much with atomic operations.
--
Olivier Gautherot
https://www.linkedin.com/in/ogautherot/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2019-09-27 16:27:11 | Re: Transactions in one table |
| Previous Message | JORGE MALDONADO | 2019-09-27 16:21:58 | Transactions in one table |