PostgreSQL 8.4.22 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Fast Forward | Next |
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.