[HACKERS] calling plpgsql from c

2003-11-18 Thread Max Jacob
Hallo, 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

[HACKERS] calling functions through a pointer

2003-10-03 Thread Max Jacob
Hallo, I wonder if there is a way to call functions in plpgsql having their oid. As an example: suppose i have a table that contains oids to functions and i have some statements that select some rows and must call the corresponding functions. Of course i can do it using dynamic sql (building

[HACKERS] SetQuerySnapshot in 7.4

2003-09-14 Thread Max Jacob
Hallo to everybody. I have found out that statements in a function beheave differently than root statements due to the fact that statements inside a function do not update the db snapshot. I already read the discussions in the archieve before 7.3 release, but i still disagree strongly with