| PostgreSQL 8.3.23 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.