Hi, On 2017-12-07 20:48:06 +0000, Greg Stark wrote: > But then I thought about it a bit and I do wonder. I don't know how > well we test having multiple portals doing all kinds of different > query plans with their execution interleaved.
Cursors test that pretty well. > And I definitely have doubts whether you can start SPI sessions from > arbitrary points in the executor expression evaluation and don't know > what state you can leave and resume them from on subsequent > evaluations... SPI being weird doesn't really have that much bearing on the executor structure imo. But I'm unclear what you'd use SPI for that really necessitates that. We don't suspend execution it the middle of function execution... Greetings, Andres Freund