Re: CREATE INDEX with an expression in an INCLUDE column fails with XX000 "unrecognized node type" instead of 0A000 on master

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Maaz Syed Adeeb <maaz(dot)adeeb(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, matthew(dot)ripley28(at)gmail(dot)com
Subject: Re: CREATE INDEX with an expression in an INCLUDE column fails with XX000 "unrecognized node type" instead of 0A000 on master
Date: 2026-07-16 16:04:24
Message-ID: 3789751.1784217864@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Maaz Syed Adeeb <maaz(dot)adeeb(at)gmail(dot)com> writes:
> Attaching a patch with two regress tests. Let me know if I need to
> change anything.

Thanks. index_including.sql embodies all sorts of anti-patterns
for testing: use of very generic object names that could conflict
with concurrent test scripts, constant dropping and re-creation
of objects ensuring that the overhead per useful test is as high
as possible, etc. But it's not the job of this patch to improve
that, so I guess the fact that you faithfully copied the existing
style is fine. I used your test as-is and pushed it. Thanks
again for the report!

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Masahiko Sawada 2026-07-16 19:23:08 Re: uuidv7 improperly accepts dates before 1970-01-01
Previous Message PG Bug reporting form 2026-07-16 15:23:23 BUG #19554: No match for argument: postgresql18-server Error: Unable to find a match: postgresql18-server