I'm trying to call plpgsql functions from c functions directly through the Oid, but i have a problem: it seems that the plpgsql interpreter calls SPI_connect and fails even if the caller has already spi-connected. I am working on recursive functions in c and so i can not call SPI_finish by myself before calling the plpgsql function since i would loose tons of stuff (or am i missing something?). Now, is there a way to work around this? If not: wouldn't it be meaningful to change this behavior?
thank you
max.
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match