>>>>> "Jack" == Jack LIU <toliuji...@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)
