=?UTF-8?Q?Torsten_F=C3=B6rtsch?= <tfoertsch123@xxxxxxxxx> writes: > postgres=# with i(x) as (values (1::int)), j(y) as (values (2::int)) select > x from (select x from i union all select y from j) b; > x > --- > 1 > 2 > (2 rows) > postgres=# with i(x) as (values (1::int)), j(y) as (values (2::int)) select > max(x) from (select x from i union all select y from j) b; > ERROR: could not find plan for CTE "i" Yup, sure looks like a bug to me, especially since it seems to work as expected before 9.5. No idea offhand what broke it. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general