manpagez: man pages & more
man SPI_push(3)
Home | html | info | man
SPI_push(3)             PostgreSQL 9.4.15 Documentation            SPI_push(3)




NAME

       SPI_push - push SPI stack to allow recursive SPI usage


SYNOPSIS

       void SPI_push(void)


DESCRIPTION

       SPI_push should be called before executing another procedure that might
       itself wish to use SPI. After SPI_push, SPI is no longer in a
       "connected" state, and SPI function calls will be rejected unless a
       fresh 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.

       Note that SPI_execute and related functions automatically do the
       equivalent of SPI_push before 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 SPI_push and
       SPI_pop.



PostgreSQL 9.4.15                    2017                          SPI_push(3)

PostgreSQL 9.4.15 - Generated Wed Nov 29 15:57:55 CST 2017
© manpagez.com 2000-2024
Individual documents may contain additional copyright information.