Re: pg17: XX000: no relation entry for relid 0

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Tender Wang <tndrwang(at)gmail(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: pg17: XX000: no relation entry for relid 0
Date: 2026-04-11 07:57:21
Message-ID: CAMbWs4_v_wrEBK1xPWxeX7Sr-EwD3k+GYG4ioiXfc302Qn=8uA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Apr 11, 2026 at 10:32 AM Tender Wang <tndrwang(at)gmail(dot)com> wrote:
> Richard Guo <guofenglinux(at)gmail(dot)com> 于2026年4月10日周五 22:39写道:
> > This looks like the right fix to me. We can use some comment here.

> comments added.
> Please see the attached patch.

I've pushed and back-patched the fix after some tweaks to the comment
and commit message. I also used explain (verbose, costs off) in the
test case so that we can observe that the inner UNION ALL's output
type doesn't match the outer's.

Thanks for the report and the patch.

- Richard

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2026-04-11 08:36:51 Re: FOR PORTION OF does not recompute GENERATED STORED columns that depend on the range column
Previous Message Thomas Munro 2026-04-11 06:35:18 Re: Automatically sizing the IO worker pool