On Oct 05 03:34, Tom Lane wrote: > Volkan YAZICI <[EMAIL PROTECTED]> writes: > > When I allocate a new memory context via > > > oldmcxt = AllocSetContextCreate(TopMemoryContext, ...) > > persistent_mcxt = CurrentMemoryContext; > > ITYM > > persistent_mcxt = AllocSetContextCreate(TopMemoryContext, ...)
Opps! Right. (I was looking at some MemoryContextSwitchTo() code while typing above lines.) > because the other doesn't do what you think... > > > How can I store the persistent_mcxt in a persistent place that I'll be > > able to reach it in my next getting invoked? > > Make it a static variable. I had thought some kind of fcinfo->flinfo->fn_extra trick but... a static variable is fair enough too. Thanks so much for the answer (also for your reply to caching subjected post). Regards. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match