On Sun, Jul 24, 2016 at 12:40 PM, Amit Kapila <amit.kapil...@gmail.com>

> In short, why do you think
> it is better to create a new context rather than using "SPI Exec"?

I think life span of the memory allocated from "SPI Exec" is only within
"Executor", and after that SPI_Exec
will be reset. But many places we need such memory beyond "Executor"(including
one which is reported in above issue).

If we see below example of exec_stmt_dynexecute.



querystr = pstrdup(querystr);

SPI_Execute --> inside this SPI_Exec context will be reset.

After this querystr is being used in this function.

Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

Reply via email to