Re: recursive query crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: "Gregory Stark" <stark(at)enterprisedb(dot)com>, Postgres <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: recursive query crash
Date: 2008-10-13 00:44:09
Message-ID: 18403.1223858649@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

OK, I found a real solution: we can fix nodeWorktablescan.c so that the
order of initialization doesn't matter, by postponing the steps that
need information from the RecursiveUnion node until the first exec call
for the worktable node.

Although nodeCtescan is making a similar assumption about initialization
order, I think that one ought to be safe. We can always change it later
if need be.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-10-13 01:00:02 Re: [PATCH] Extending pg_class info + more flexible TOAST chunk size
Previous Message Grzegorz Jaskiewicz 2008-10-12 23:14:14 Re: SELECT TOP %d PERCENT, or SELECT ... LIMIT %d PERCENT ?