Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)

PG Bug reporting form <noreply@postgresql.org> writes:
> Trying to run simple SELECT COUNT(*) from some table gives me the following
> error (either running by hand or trying to run EXPLAIN using pgadmin or by
> hand):

> 2022-05-09 00:06:30.428 CEST [1196] ERROR:  variable not found in subplan
> target list
> 2022-05-09 00:06:30.428 CEST [1196] STATEMENT:  SELECT COUNT(*) FROM
> "domino_efekty_havarijniprojev"

Is that really just a table?  I could believe a bug like this for
some types of views, but it's a bit hard to credit for a plain table.

In any case, we can't do much with this report unless you can provide
a reproducer case --- preferably a SQL script that creates an object
that triggers the problem.

            regards, tom lane