| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
| Cc: | Postgres <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: recursive query crash |
| Date: | 2008-10-11 15:25:09 |
| Message-ID: | 21910.1223738709@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Gregory Stark <stark(at)enterprisedb(dot)com> writes:
> This crashes, apparently it tries to look up the result type on a NULL
> planstate:
Tsk tsk, running CVS HEAD without Asserts?
It looks like things are getting initialized in the wrong order. Maybe
we need to attach the initplan lower down.
> Incidentally, why are the parentheses required around the second branch of the
> union?
AFAICT, the spec's grammar won't let you put WITH there at all, even
with the parens; but it's definitely invalid without --- note their
distinction between <query expression> and <query expression body>.
We'll see if we can make it work in PG though.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | iihero | 2008-10-11 15:32:40 | Re: About postgresql8.3.3 build in MS VS2005 |
| Previous Message | D'Arcy J.M. Cain | 2008-10-11 15:03:36 | Re: The Axe list |