pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Guo <guofenglinux@gmail.com>
Cc: 10215501441@stu.ecnu.edu.cn, Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19653: "variable not found in subplan target list" during planning with parallel parameterized nested loop,
Date: Mon, 07 Sep 2026 11:08:39 -0400
Message-ID: <232570.1788793719@sss.pgh.pa.us> (raw)
In-Reply-To: <CAMbWs4913G2ZWwEFbc=65zibQcqbY2nhxtFmHEx7KF+jfsGtVQ@mail.gmail.com>
References: <19653-9352cc6ba17b662f@postgresql.org>
	<1564958.1788530496@sss.pgh.pa.us>
	<1570204.1788535631@sss.pgh.pa.us>
	<CAMbWs4_aJo_wEQCzT=mLBSQEdKt-J0OM5weZtt-szZSKvnPusw@mail.gmail.com>
	<CAMbWs48OyF+JAiP-c3YxswVTK1mbjO-RNWFB0JXV7xdaC6HmPg@mail.gmail.com>
	<116500.1788717110@sss.pgh.pa.us>
	<CAMbWs49tzZzriJGqZ+1y7njh0=4sMGm3vOvAUmBo8r_Yqp=1SQ@mail.gmail.com>
	<157316.1788751833@sss.pgh.pa.us>
	<CAMbWs4913G2ZWwEFbc=65zibQcqbY2nhxtFmHEx7KF+jfsGtVQ@mail.gmail.com>

Richard Guo <guofenglinux@gmail.com> writes:
> On Mon, Sep 7, 2026 at 12:30 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Yeah, I tried adjusting things like that and the regression tests
>> immediately crashed.  So now I think we have to do it as you have it;
>> but maybe the comment could be improved to explain that we need to
>> match both Vars having the child relid and PHVs having top-parent
>> relids.

> Done in the attached.

This version LGTM.

			regards, tom lane






view thread (12+ messages)  latest in thread

Message-ID: <232570.1788793719@sss.pgh.pa.us>
Permalink:  ../232570.1788793719@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/232570.1788793719@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, guofenglinux@gmail.com, robertmhaas@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #19653: "variable not found in subplan target list" during planning with parallel parameterized nested loop,
  In-Reply-To: <232570.1788793719@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox