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

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Richard Guo <guofenglinux(at)gmail(dot)com>
Cc: Tender Wang <tndrwang(at)gmail(dot)com>, 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>
Subject: Re: pg17: XX000: no relation entry for relid 0
Date: 2026-04-10 20:34:34
Message-ID: adle2skiU3ArG9sV@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Apr 10, 2026 at 11:38:50PM +0900, Richard Guo wrote:
> Nice catch. It seems that we need at least three branches to
> reproduce this, so that there's a nested UNION ALL whose output type
> doesn't match the parent's expected type. At the outer branch maybe
> we can use NULL::bigint[] instead to be a little simpler.

Indeed, three branches:
$ git branch --contains 9391f7152
+ REL_17_STABLE
+ REL_18_STABLE
* master
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Haibo Yan 2026-04-10 21:48:32 Re: Extract numeric filed in JSONB more effectively
Previous Message SATYANARAYANA NARLAPURAM 2026-04-10 20:18:36 Infinite Autovacuum loop caused by failing virtual generated column expression