Sorry about that. Couldn't seem to get a simple reproduction. I have now attached a straightforward one. I am not sure why so many columns are required to cause the error, so it'd be nice to understand that too.
-Ryan
On Thu, Feb 10, 2022 at 11:03 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ryan Kelly <rpkelly22@gmail.com> writes: > After upgrading to 11.15 we have queries failing as follows: > (postgres@[local]:5432 02:52:54) [capitalrx_test_adjudication_master]> > EXPLAIN SELECT count(*) FROM adjudication.claims; > ERROR: XX000: variable not found in subplan target list
It's impossible to comment on this with this amount of detail. Please try to extract a self-contained test case.