Document SPI_push() and SPI_pop().

bmomjian · bmomjian · commit d245b6bd9f55 · 2004-03-17T01:05:10.000Z
diff --git a/doc/src/sgml/spi.sgml b/doc/src/sgml/spi.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/spi.sgml,v 1.32 2004/03/05 01:00:45 momjian Exp $
+$PostgreSQL: pgsql/doc/src/sgml/spi.sgml,v 1.33 2004/03/17 01:05:10 momjian Exp $
 -->
 
 <chapter id="spi">
@@ -199,6 +199,68 @@ int SPI_finish(void)
 
 <!-- *********************************************** -->
 
+<refentry id="spi-spi-push">
+ <refmeta>
+  <refentrytitle>SPI_push</refentrytitle>
+ </refmeta>
+
+ <refnamediv>
+  <refname>SPI_push</refname>
+  <refpurpose>pushes SPI stack to allow recursive SPI calls</refpurpose>
+ </refnamediv>
+
+ <indexterm><primary>SPI_push</primary></indexterm>
+
+ <refsynopsisdiv>
+<synopsis>
+void SPI_push(void)
+</synopsis>
+ </refsynopsisdiv>
+
+ <refsect1>
+  <title>Description</title>
+
+  <para>
+   <function>SPI_push</function> pushes a new environment on to the 
+   SPI call stack, allowing recursive calls to use a new environment.
+  </para>
+ </refsect1>
+
+</refentry>
+
+<!-- *********************************************** -->
+
+<refentry id="spi-spi-pop">
+ <refmeta>
+  <refentrytitle>SPI_pop</refentrytitle>
+ </refmeta>
+
+ <refnamediv>
+  <refname>SPI_pop</refname>
+  <refpurpose>pops SPI stack to allow recursive SPI calls</refpurpose>
+ </refnamediv>
+
+ <indexterm><primary>SPI_pop</primary></indexterm>
+
+ <refsynopsisdiv>
+<synopsis>
+void SPI_pop(void)
+</synopsis>
+ </refsynopsisdiv>
+
+ <refsect1>
+  <title>Description</title>
+
+  <para>
+   <function>SPI_pop</function> pops the previous environment from the 
+   SPI call stack.  For use when returning from recursive SPI calls.
+  </para>
+ </refsect1>
+
+</refentry>
+
+<!-- *********************************************** -->
+
 <refentry id="spi-spi-exec">
  <refmeta>
   <refentrytitle>SPI_exec</refentrytitle>
diff --git a/src/backend/executor/spi.c b/src/backend/executor/spi.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/src/backend/executor/spi.c,v 1.110 2004/03/05 00:47:01 momjian Exp $
+ *	  $PostgreSQL: pgsql/src/backend/executor/spi.c,v 1.111 2004/03/17 01:05:10 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -201,12 +201,14 @@ AtEOXact_SPI(bool isCommit)
 	SPI_tuptable = NULL;
 }
 
+/* Pushes SPI stack to allow recursive SPI calls */
 void
 SPI_push(void)
 {
 	_SPI_curid++;
 }
 
+/* Pops SPI stack to allow recursive SPI calls */
 void
 SPI_pop(void)
 {
diff --git a/src/include/executor/spi.h b/src/include/executor/spi.h
@@ -2,7 +2,7 @@
  *
  * spi.h
  *
- * $PostgreSQL: pgsql/src/include/executor/spi.h,v 1.42 2004/03/05 00:47:01 momjian Exp $
+ * $PostgreSQL: pgsql/src/include/executor/spi.h,v 1.43 2004/03/17 01:05:10 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -81,8 +81,8 @@ extern int	SPI_connect(void);
 extern int	SPI_finish(void);
 extern void SPI_push(void);
 extern void SPI_pop(void);
-extern int	SPI_exec(const char *src, int tcount);
-extern int SPI_execp(void *plan, Datum *values, const char *Nulls,
+extern int  SPI_exec(const char *src, int tcount);
+extern int  SPI_execp(void *plan, Datum *values, const char *Nulls,
 		  int tcount);
 extern int SPI_execp_current(void *plan, Datum *values, const char *Nulls,
 							 bool useCurrentSnapshot, int tcount);

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $PostgreSQL: pgsql/src/backend/executor/spi.c,v 1.110 2004/03/05 00:47:01 momjian Exp $`
	`11`	`+ * $PostgreSQL: pgsql/src/backend/executor/spi.c,v 1.111 2004/03/17 01:05:10 momjian Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -201,12 +201,14 @@ AtEOXact_SPI(bool isCommit)`
`201`	`201`	`SPI_tuptable = NULL;`
`202`	`202`	`}`
`203`	`203`
	`204`	`+/* Pushes SPI stack to allow recursive SPI calls */`
`204`	`205`	`void`
`205`	`206`	`SPI_push(void)`
`206`	`207`	`{`
`207`	`208`	`_SPI_curid++;`
`208`	`209`	`}`
`209`	`210`
	`211`	`+/* Pops SPI stack to allow recursive SPI calls */`
`210`	`212`	`void`
`211`	`213`	`SPI_pop(void)`
`212`	`214`	`{`
Original file line number	Diff line number	Diff line change
`@@ -2,7 +2,7 @@`
`2`	`2`	`*`
`3`	`3`	`* spi.h`
`4`	`4`	`*`
`5`		`- * $PostgreSQL: pgsql/src/include/executor/spi.h,v 1.42 2004/03/05 00:47:01 momjian Exp $`
	`5`	`+ * $PostgreSQL: pgsql/src/include/executor/spi.h,v 1.43 2004/03/17 01:05:10 momjian Exp $`
`6`	`6`	`*`
`7`	`7`	`*-------------------------------------------------------------------------`
`8`	`8`	`*/`
`@@ -81,8 +81,8 @@ extern int SPI_connect(void);`
`81`	`81`	`extern int SPI_finish(void);`
`82`	`82`	`extern void SPI_push(void);`
`83`	`83`	`extern void SPI_pop(void);`
`84`		`-extern int SPI_exec(const char *src, int tcount);`
`85`		`-extern int SPI_execp(void plan, Datum values, const char *Nulls,`
	`84`	`+extern int SPI_exec(const char *src, int tcount);`
	`85`	`+extern int SPI_execp(void plan, Datum values, const char *Nulls,`
`86`	`86`	`int tcount);`
`87`	`87`	`extern int SPI_execp_current(void plan, Datum values, const char *Nulls,`
`88`	`88`	`bool useCurrentSnapshot, int tcount);`