MIME-Version: 1.0
References: 
 <CANNsrHt-3wC-nGG_owzfKfx+N-sHWFuJQ=QEivGrXGK2_ne0xA@mail.gmail.com>
 <3352436.1678116090@sss.pgh.pa.us>
In-Reply-To: <3352436.1678116090@sss.pgh.pa.us>
From: Flaris Feller <flaris.feller@gmail.com>
Date: Mon, 6 Mar 2023 20:33:45 -0300
Message-ID: 
 <CANNsrHtZwfrsrz7z6Y7Nhe+DmST_QmeJ=MWAZpMxt8+iCPHGAA@mail.gmail.com>
Subject: Re: Transaction control in a C language function
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000000c1ff105f643bcad"
Archived-At: 
 <https://www.postgresql.org/message-id/CANNsrHtZwfrsrz7z6Y7Nhe%2BDmST_QmeJ%3DMWAZpMxt8%2BiCPHGAA%40mail.gmail.com>
Precedence: bulk

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

Hello Tom,
You are absolutely right, I was calling it from a function instead of a
procedure.
The documentation should mention that.
Thanks for your clarification.
Regards,
Flaris.

Em seg., 6 de mar. de 2023 =C3=A0s 12:21, Tom Lane <tgl@sss.pgh.pa.us> escr=
eveu:

> Flaris Feller <flaris.feller@gmail.com> writes:
> > I would like to implement transaction control in a function implemented
> in
> > C language.
>
> That will certainly not work unless you make it a procedure.
> It'd be a good idea also to check that the CALL came from a
> non-atomic context.
>
>                         regards, tom lane
>


--=20
Flaris Roland Feller
https://www.linkedin.com/in/flarisfeller

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

<div dir=3D"ltr"><div>Hello Tom,</div><div>You are absolutely right, I was =
calling it from a function instead of a procedure.</div><div>The documentat=
ion should mention that.<br></div><div>Thanks for your clarification.</div>=
<div>Regards,</div><div>Flaris.<br></div></div><br><div class=3D"gmail_quot=
e"><div dir=3D"ltr" class=3D"gmail_attr">Em seg., 6 de mar. de 2023 =C3=A0s=
 12:21, Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us=
</a>&gt; escreveu:<br></div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1e=
x">Flaris Feller &lt;<a href=3D"mailto:flaris.feller@gmail.com" target=3D"_=
blank">flaris.feller@gmail.com</a>&gt; writes:<br>
&gt; I would like to implement transaction control in a function implemente=
d in<br>
&gt; C language.<br>
<br>
That will certainly not work unless you make it a procedure.<br>
It&#39;d be a good idea also to check that the CALL came from a<br>
non-atomic context.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div><br clear=3D"all"><br><span class=3D"gmail_signature_pre=
fix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"l=
tr">Flaris Roland Feller<div></div><div><a href=3D"https://www.linkedin.com=
/in/flarisfeller" target=3D"_blank">https://www.linkedin.com/in/flarisfelle=
r</a><br></div></div></div>

--0000000000000c1ff105f643bcad--