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

Hi,

the simplest script is something like:

create extension if not exists postgis;
CREATE TABLE IF NOT EXISTS public.table_with_geom
(
    id integer NOT NULL,
    geom geometry(Point,5514)
);
CREATE INDEX IF NOT EXISTS table_with_geom_id ON table_with_geom USING gist
(geom);
SET enable_seqscan = OFF;
SET enable_bitmapscan = OFF;
explain select count(*) from table_with_geom;

This should print:

NOTICE: extension "postgis" already exists, skipping ERROR: variable not
found in subplan target list SQL state: XX000

Regards

--

Milosh

---------- Původní e-mail ----------
Od: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Komu: milos(dot)urbanek(at)email(dot)cz
Datum: 9. 5. 2022 2:22:10
Předmět: Re: BUG #17476: ERROR: "variable not found in subplan target list"
when running SELECT COUNT(*)
"PG Bug reporting form <noreply(at)postgresql(dot)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
"