|The PostgreSQL 9.0 Reference Manual - Volume 2 - Programming Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 478 pages
RRP £14.95 ($19.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
SPI_push -- push SPI stack to allow recursive SPI usage
SPI_push should be called before executing another
procedure that might itself wish to use SPI.
SPI_push, SPI is no longer in a
“connected” state, and SPI function calls will be rejected unless
SPI_connect is done. This ensures a clean
separation between your procedure's SPI state and that of another procedure
you call. After the other procedure returns, call
SPI_pop to restore access to your own SPI state.
SPI_execute and related functions
automatically do the equivalent of
passing control back to the SQL execution engine, so it is not necessary
for you to worry about this when using those functions.
Only when you are directly calling arbitrary code that might contain
SPI_connect calls do you need to issue
|ISBN 9781906966065||The PostgreSQL 9.0 Reference Manual - Volume 2 - Programming Guide||See the print edition|