Re: pgsql/src/backend/optimizer/prep prepunion.c

Tom, thanks for fixing this. I couldn't verify the bug because the test
case was so complex.

> CVSROOT: /home/projects/pgsql/cvsroot
> Module name: pgsql
> Changes by: tgl(at)hub(dot)org 01/08/14 13:12:57
>
> Modified files:
> src/backend/optimizer/prep: prepunion.c
>
> Log message:
> Fix brokenness of nested EXCEPT/INTERSECT queries. prepunion was being
> a tad sloppy about generating the targetlist for some nodes, by generating
> a tlist entry that claimed to be a constant when the value wasn't actually
> constant. This caused setrefs.c to do the wrong thing later on.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026