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

Reply via email to