From aa728d5f4b18e23eeb27f12acc9c44b441fc5986 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 18 Feb 2007 01:47:40 +0000 Subject: [PATCH] Document limitation of SPI_execute() using multiple queries in a single string. --- doc/src/sgml/spi.sgml | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/spi.sgml b/doc/src/sgml/spi.sgml index 88461e71ba..90a68a5d01 100644 --- a/doc/src/sgml/spi.sgml +++ b/doc/src/sgml/spi.sgml @@ -1,4 +1,4 @@ - + Server Programming Interface @@ -321,7 +321,8 @@ SPI_execute("INSERT INTO foo SELECT * FROM bar", false, 5); - You can pass multiple commands in one string. + You can pass multiple commands in one string, but later commands cannot + depend on the creation of objects earlier in the string. SPI_execute returns the result for the command executed last. The count limit applies to each command separately, but it is not applied to -- 2.11.0