SPI_keepplan
Name
SPI_keepplan -- save a prepared statement
Synopsis
int SPI_keepplan(SPIPlanPtr plan)
Description
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.
Arguments
- SPIPlanPtr plan
-
the prepared statement to be saved
Return Value
0 on success; SPI_ERROR_ARGUMENT if
plan is NULL
or invalid
Notes
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.