[HACKERS] Stateful pointers in set-returning functions

Hi, I'm writing a set-returning function which places a file handle into PG's FuncCallContext's user_fctx space. My problem is that when the function is ran with a limit clause (SELECT * FROM foo() LIMIT 10) the server will stop calling the function automatically, not giving me a chance to close

Re: [HACKERS] Stateful pointers in set-returning functions

Ian Pye ian...@gmail.com writes: I'm writing a set-returning function which places a file handle into PG's FuncCallContext's user_fctx space. My problem is that when the function is ran with a limit clause (SELECT * FROM foo() LIMIT 10) the server will stop calling the function automatically,

Re: [HACKERS] Stateful pointers in set-returning functions

Fair enough -- thanks for the tip. On Thu, May 24, 2012 at 11:21 AM, Tom Lane t...@sss.pgh.pa.us wrote: Ian Pye ian...@gmail.com writes: I'm writing a set-returning function which places a file handle into PG's FuncCallContext's user_fctx space. My problem is that when the function is ran