Re: BUG #18147: ERROR: invalid perminfoindex 0 in RTE with relid xxxxx - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #18147: ERROR: invalid perminfoindex 0 in RTE with relid xxxxx
Date
Msg-id CAKFQuwYFq-Q2rxbXXBmdHCAEFm-Pu_qhPAEi-PO+LmjtYN2hhg@mail.gmail.com
Whole thread Raw
In response to BUG #18147: ERROR: invalid perminfoindex 0 in RTE with relid xxxxx  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18147: ERROR: invalid perminfoindex 0 in RTE with relid xxxxx  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Thu, Oct 5, 2023 at 8:05 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18147
Logged by:          Hans Buschmann
Email address:      buschmann@nidsa.net
PostgreSQL version: 16.0
Operating system:   Fedora 38 x86-64 64bit, also on Win64
Description:       

The query is quite simplified.. Perhaps it is good to now, that the table
or_followup has an inherited table or_followup_archiv (= relid 17034) which
is chosen by of_season and has not the same index definitions as
or_followup.


The simplified query is preferred so long as it produces the error - but you really should be providing the create table commands to make the entire script self-contained.

David J.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #18148: Handle null in a date/time fields when passing empty arrays issue
Next
From: Tom Lane
Date:
Subject: Re: BUG #18147: ERROR: invalid perminfoindex 0 in RTE with relid xxxxx