On Wed, 2006-12-27 at 18:05 -0500, Tom Lane wrote: > "Simon Riggs" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend