>>>>> "Jack" == Jack LIU <toliujiayi(at)gmail(dot)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)