Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18305: Unexpected error: "WindowFunc not found in subplan target lists" triggered by subqueries - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18305: Unexpected error: "WindowFunc not found in subplan target lists" triggered by subqueries
Date
Msg-id 3968320.1706017975@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #18305: Unexpected error: "WindowFunc not found in subplan target lists" triggered by subqueries  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-bugs
Tree view 
Richard Guo <guofenglinux@gmail.com> writes:
> Hmm, is there a way to detect in find_window_run_conditions() whether
> the WindowFunc's argument references a SubLink node of a subquery that
> hasn't been pulled up?

contain_subplans will recognize both SubLinks and SubPlans,
so there must be some other factor here.  (I didn't look yet.)

            regards, tom lane

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18306: Slow SQL query Postgresql 15 Debian family linux.
Next
From: Casey
Date:
Subject: Re: Misleading/inaccurate error message from pg_basebackup