Re: Transactions in one table

--0000000000008c9ce905938b5cc8
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Sep 27, 2019 at 9:22 AM JORGE MALDONADO <[email protected]>
wrote:

> 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=C2=B4s it=
.
>

Its not necessary to explicitly issue a begin/commit but it also isn't
something to actively avoid.

Dave

--0000000000008c9ce905938b5cc8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Fri, Sep 27, 2019 at 9:22 AM JORGE MALDONADO &lt;<a hre=
f=3D"mailto:[email protected]">[email protected]</a>&gt; wrote:</=
span><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,=
204);padding-left:1ex"><div dir=3D"ltr"><div>Does it make any sense to use =
transactions if only one DB operation is performed in only one table?<br></=
div><div>For example, insert only one record in a &quot;countries&quot; tab=
le without doing anything else in other table(s). One operation, one table,=
 that=C2=B4s it.</div></div></blockquote><div><br></div><div class=3D"gmail=
_default" style=3D"font-family:arial,helvetica,sans-serif">Its not necessar=
y to explicitly issue a begin/commit but it also isn&#39;t something to act=
ively avoid.</div><div class=3D"gmail_default" style=3D"font-family:arial,h=
elvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-f=
amily:arial,helvetica,sans-serif">Dave</div><div class=3D"gmail_default" st=
yle=3D"font-family:arial,helvetica,sans-serif"><br></div></div></div>

--0000000000008c9ce905938b5cc8--