From: Tom Lane <tgl@sss.pgh.pa.us>
To: milos.urbanek@email.cz
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)
Date: Sun, 08 May 2022 20:22:01 -0400
Message-ID: <3488097.1652055721@sss.pgh.pa.us> (raw)
In-Reply-To: <17476-cf579fc6b204baa2@postgresql.org>
References: <17476-cf579fc6b204baa2@postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, milos.urbanek@email.cz, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)
In-Reply-To: <3488097.1652055721@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox