SPI_saveplan
saves a passed plan (prepared by SPI_prepare
) in memory that will not be freed by SPI_finish
nor by the transaction manager, and returns a pointer to the saved plan. This gives you the ability to reuse prepared plans in the subsequent invocations of your procedure in the current session.
Pointer to the saved plan; NULL if unsuccessful. On error, SPI_result is set thus:
if plan is NULL or invalid
if called from an unconnected procedure
The passed-in plan is not freed, so you might wish to do SPI_freeplan
on it to avoid leaking memory until SPI_finish
.
If one of the objects (a table, function, etc.) referenced by the prepared plan is dropped or redefined, then future executions of SPI_execute_plan
may fail or return different results than the plan initially indicates.