Horton

Re: foreign join error "variable not found in subplan target list"

Richard Guo <guofenglinux@gmail.com>

View thread View on postgr.es
From: Richard Guo <guofenglinux@gmail.com>
To: Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Cc: Etsuro Fujita <etsuro.fujita@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2022-08-12T03:09:50Z
Lists: pgsql-bugs 
On Wed, Aug 10, 2022 at 11:17 PM Alexander Pyhalov <a.pyhalov@postgrespro.ru>
wrote:

> OK. It looks good to me. The only thing which surprised me that in test
> case we see unnecessary sort in remote query. However, it's explained by
> selected costs and STD_FUZZ_FACTOR, so that sorted path has essentially
> the same cost as non-sorted one according to
> compare_path_costs_fuzzily().


Yeah, and meanwhile the sorted path is considered to have better
pathkeys than the non-sorted one. So it wins in add_path().

Thanks
Richard

Commits

  1. postgres_fdw: Avoid 'variable not found in subplan target list' error.