Re: Transaction control in a C language function

From: Flaris Feller <flaris(dot)feller(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-interfaces(at)lists(dot)postgresql(dot)org
Subject: Re: Transaction control in a C language function
Date: 2023-03-06 23:33:45
Message-ID: CANNsrHtZwfrsrz7z6Y7Nhe+DmST_QmeJ=MWAZpMxt8+iCPHGAA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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 às 12:21, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> escreveu:

> Flaris Feller <flaris(dot)feller(at)gmail(dot)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
>

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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message pgchem pgchem 2023-04-12 07:35:10 C trigger significantly slower than PL/pgSQL?
Previous Message Andres Freund 2023-03-06 18:15:11 Re: About default inBufSize (connection read buffer size) in libpq