Re: Inconsistent RestrictInfo serial numbers

From: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
To: Richard Guo <guofenglinux(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Inconsistent RestrictInfo serial numbers
Date: 2024-11-06 14:06:36
Message-ID: CAExHW5tPE_hX9uAT_O2gC0PaVpG-EhQLa9gT-WSJamyNwdO4xw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Nov 6, 2024 at 4:10 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
>
> On Tue, Oct 8, 2024 at 8:20 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> >
> > I ran into an "ERROR: variable not found in subplan target lists"
> > error, which can be reproduced with the following query.
>
> > To fix, I think we can reset the root->last_rinfo_serial counter after
> > generating the additional constant-FALSE RestrictInfo. Please see
> > attached.
>
> I intend to push this patch shortly, barring any objections, so that
> it can catch up with the next minor release (Nov. 14).

I didn't get time to respond to your email and create a patch based on
my proposal. Sorry. I may not get time for another week or so. Please
feel free to push the patch, if you feel that it's in a committable
state.

--
Best Wishes,
Ashutosh Bapat

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2024-11-06 14:29:59 Re: index_delete_sort: Unnecessary variable "low" is used in heapam.c
Previous Message Bertrand Drouvot 2024-11-06 13:51:02 Re: per backend I/O statistics