Re: BUG #19037: Planner fails on estimating array length with "no relation entry" error

Alexander Lakhin <exclusion@gmail.com>

From: Alexander Lakhin <exclusion@gmail.com>
To: Richard Guo <guofenglinux@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2025-09-05T04:00:00Z
Lists: pgsql-bugs
Hello Tom and Richard,

03.09.2025 11:08, Richard Guo wrote:
>> Yeah, "is there any other instance of this problem?" is the $64
>> question here.  I was initially thinking v17 is sufficient, but
>> the possibility that some extension might be vulnerable makes
>> me lean to back-patching further.  Your call ...
> I've decided to backpatch this fix to pre-v17 branches: using a root
> that lacks a valid simple_rel_array in a cost estimation function
> seems like a pitfall waiting to happen.  I've included an explanation
> of this backpatch decision in the commit message and have pushed the
> fix (the test case is not included in pre-v17 branches though).

Thank you for fixing that anomaly!

Best regards,
Alexander