On Sun, Jul 24, 2016 at 12:40 PM, Amit Kapila <amit.kapil...@gmail.com> wrote:
> 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. 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. } -- Regards, Dilip Kumar EnterpriseDB: http://www.enterprisedb.com