Re: SPI Interface to Call Procedure with Transaction Control Statements?

>>>>> "Jack" == Jack LIU <toliujiayi@gmail.com> writes:

 Jack> Hi Andrew,
 Jack> This is my code to call the procedure with
 Jack> SPI_connect_ext(SPI_OPT_NONATOMIC).

Ah. You need to take a look at exec_stmt_call in plpgsql, and do the
same things it does with snapshot management (specifically, setting the
no_snapshot flag on the plan that you're going to execute). SPI forces
atomic mode if the normal snapshot management is in use, because
otherwise a commit inside the procedure would warn about still having a
snapshot open.

-- 
Andrew (irc:RhodiumToad)