Re: Inconsistent RestrictInfo serial numbers

Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>

From: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
To: Richard Guo <guofenglinux@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2024-11-06T14:06:36Z
Lists: pgsql-hackers
On Wed, Nov 6, 2024 at 4:10 PM Richard Guo <guofenglinux@gmail.com> wrote:
>
> On Tue, Oct 8, 2024 at 8:20 PM Richard Guo <guofenglinux@gmail.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



Commits

  1. Fix inconsistent RestrictInfo serial numbers

  2. Recalculate where-needed data accurately after a join removal.

  3. Add better handling of redundant IS [NOT] NULL quals