Re: (SQL/PGQ) cache lookup failed for label - Mailing list pgsql-hackers

From Ewan Young
Subject Re: (SQL/PGQ) cache lookup failed for label
Date
Msg-id CAON2xHMc413gJAm-reap=mF_N2Mqh=SQuK1k7GdwtFZLnjujkg@mail.gmail.com
Whole thread
In response to Re: (SQL/PGQ) cache lookup failed for label  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
List pgsql-hackers
Hi Ashutosh,

On Thu, Jun 4, 2026 at 7:46 PM Ashutosh Bapat
<ashutosh.bapat.oss@gmail.com> wrote:
>
> Hi Ewan,
>
> On Thu, Jun 4, 2026 at 4:52 PM Ewan Young <kdbase.hack@gmail.com> wrote:
> >
> >
> > I don't think these are the same bug. I applied v20260601-0005
> > through 0007 on top of master (90354030b8f) and my test case still
> > fails the same way:
>
> Sorry to redirect you to the wrong thread. Please check [1]. Hope I
> have given you the right one this time :)
>
> When submitting the next report, please check if the issue is already
> covered by an existing email thread.
>
> [1] https://www.postgresql.org/message-id/CAHg+QDfnLzsgjaQ_CiKSpP4JH3MKOiwoawEcCzXa9uYr45yiWw@mail.gmail.com

No problem, and thanks for the pointer — this time it is indeed the
same issue. I applied v20260602-0010 on top of master (90354030b8f)
and verified that it fixes my test case as well as an edge-label
variant of it; the graph_table regression test also passes. The fix
is essentially the same as the one I posted (adjusting varlevelsup of
the path queries when they get wrapped as subqueries of the UNION),
just placed in generate_setop_from_pathqueries instead, which also
looks cleaner to me. So please consider my report a duplicate of that
thread.

I will dig the archives more carefully before reporting next time :)

Regards,
Ewan Young

>
> --
> Best Wishes,
> Ashutosh Bapat



pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Fix OAuth validator docs for error_detail on internal errors
Next
From: Álvaro Herrera
Date:
Subject: Re: Fix comments to reference xlogrecovery.c