pgsql: Fix behavior of stable functions called from a CALL's argument l

2024-06-07 Thread Tom Lane
Fix behavior of stable functions called from a CALL's argument list. If the CALL is within an atomic context (e.g. there's an outer transaction block), _SPI_execute_plan should acquire a fresh snapshot to execute any such functions with. We failed to do that and instead passed them the Portal sna

pgsql: Fix behavior of stable functions called from a CALL's argument l

2024-06-07 Thread Tom Lane
Fix behavior of stable functions called from a CALL's argument list. If the CALL is within an atomic context (e.g. there's an outer transaction block), _SPI_execute_plan should acquire a fresh snapshot to execute any such functions with. We failed to do that and instead passed them the Portal sna

pgsql: Fix behavior of stable functions called from a CALL's argument l

2024-06-07 Thread Tom Lane
Fix behavior of stable functions called from a CALL's argument list. If the CALL is within an atomic context (e.g. there's an outer transaction block), _SPI_execute_plan should acquire a fresh snapshot to execute any such functions with. We failed to do that and instead passed them the Portal sna

pgsql: Fix behavior of stable functions called from a CALL's argument l

2024-06-07 Thread Tom Lane
Fix behavior of stable functions called from a CALL's argument list. If the CALL is within an atomic context (e.g. there's an outer transaction block), _SPI_execute_plan should acquire a fresh snapshot to execute any such functions with. We failed to do that and instead passed them the Portal sna

pgsql: Fix behavior of stable functions called from a CALL's argument l

2024-06-07 Thread Tom Lane
Fix behavior of stable functions called from a CALL's argument list. If the CALL is within an atomic context (e.g. there's an outer transaction block), _SPI_execute_plan should acquire a fresh snapshot to execute any such functions with. We failed to do that and instead passed them the Portal sna

pgsql: Fix behavior of stable functions called from a CALL's argument l

2024-06-07 Thread Tom Lane
Fix behavior of stable functions called from a CALL's argument list. If the CALL is within an atomic context (e.g. there's an outer transaction block), _SPI_execute_plan should acquire a fresh snapshot to execute any such functions with. We failed to do that and instead passed them the Portal sna