BUG #17782: ERROR: variable not found in subplan target lists

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: d(dot)hanzhelo(at)indevlab(dot)com
Subject: BUG #17782: ERROR: variable not found in subplan target lists
Date: 2023-02-07 13:16:22
Message-ID: 17782-23a2f2a4c868a72e@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17782
Logged by: Dmytro Hanzhelo
Email address: d(dot)hanzhelo(at)indevlab(dot)com
PostgreSQL version: 13.9
Operating system: CentOS Linux release 8.3.2011
Description:

The our client contacted us and we reproduced the error in our test
environment.
We reproduced the error on PostgresQL v.13.3 and then upgrade to v.13.9 and
still get this ERROR.
We expect a fix in the release "10.21, 11.16, 12.11, 13.7, 14.3 released
2022-05-12" but nothing.

This SQL request returned ERROR.

UPDATE corestatus.system_module
SET state=true
WHERE module_name='cfront_exchangerate';
ERROR: variable not found in subplan target lists

We can provide dump for reproduce.
Please advice.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2023-02-07 13:43:42 Re: BUG #17782: ERROR: variable not found in subplan target lists
Previous Message PG Bug reporting form 2023-02-07 13:16:08 BUG #17781: Assert in setrefs.c