Tomasz Myrta <jasiek@klaster.net> writes:
> I don't understand ERROR message at all:
> ERROR: SPI_prepare() failed on "SELECT $1 "
This is a bug. Or two bugs, actually: one of yours and one of PG's.
I have repaired the PG bug with the attached patch. The bug in your
code is that your C function needs to call SPI_connect and SPI_finish
if it's going to use any SPI operations.
regards, tom lane
Index: spi.c
===================================================================
RCS file: /cvsroot/pgsql-server/src/backend/executor/spi.c,v
retrieving revision 1.75.2.3
diff -c -r1.75.2.3 spi.c
*** spi.c 14 Feb 2003 21:12:54 -0000 1.75.2.3
--- spi.c 23 Sep 2003 15:09:39 -0000
***************
*** 1387,1393 **** elog(ERROR, "invalid portal in SPI cursor operation"); /* Push the SPI stack */
! _SPI_begin_call(true); /* Reset the SPI result */ SPI_processed = 0;
--- 1387,1394 ---- elog(ERROR, "invalid portal in SPI cursor operation"); /* Push the SPI stack */
! if (_SPI_begin_call(true) < 0)
! elog(ERROR, "SPI cursor operation called while not connected"); /* Reset the SPI result */
SPI_processed= 0;