SPI_keepplan
Name
SPI_keepplan -- save a prepared statement
Synopsis
int SPI_keepplan(SPIPlanPtr plan)
描述
SPI_keepplan
saves a passed statement (prepared by
SPI_prepare
) so that it will not be freed
by SPI_finish
nor by the transaction manager.
This gives you the ability to reuse prepared statements in the subsequent
invocations of your procedure in the current session.
参数
- SPIPlanPtr plan
the prepared statement to be saved
返回值
0 on success;
SPI_ERROR_ARGUMENT if plan
is NULL or invalid
注解
The passed-in statement is relocated to permanent storage by means
of pointer adjustment (no data copying is required). If you later
wish to delete it, use SPI_freeplan
on it.