On Wed, 2006-12-27 at 18:05 -0500, Tom Lane wrote:
> "Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> > Is it possible to allocate the subquery in a child context of the main
> > query, so that it is technically a different context, yet can be freed
> > simultaneously?
>
> That's exactly what the code *was* doing, but the problem is that we'd
> free the child context during ExecEndSubqueryScan, at which point the
> tupdesc is still needed.
OK, I guess my only other question is to do with recursive/hierarchical
queries: How will we handle those? All in same context?
I guess many subqueries are transformable into main joins anyway, so the
distinction is probably moot anyhow.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com