Re: Intermittent bug

Tom Lane wrote:

>>What life span does the context->multi_call_memory_context have in case
>>of IMMUTABLE functions that returns SETOF?
>>
>>
>It should be long enough. What's your test case exactly?
>
>
It's my PL/Java test framework that fails so it's a bit complex but if
I'm right, any immutable, set-returning function that allocates stuff in
multi_call_memory_context at first call and then reused it, should show
the same problem.

I do have a way of logging MemoryContext termination by replacing the
function pointer used for context delete with an interceptor that does
elog(DEBUG1). I'll see if I can prove that it actually get's deleted
between rows. If it does, perhaps I can find the time to write a sample.

Regards,
Thomas Hallgren