The following bug has been logged on the website:
Bug reference: 17476
Logged by: Milos Urbanek
Email address: milos.urbanek@email.cz
PostgreSQL version: 14.2
Operating system: Windows 2012 R2 Foundation
Description:
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"
2022-05-09 00:06:31.884 CEST [1196] ERROR: variable not found in subplan
target list
2022-05-09 00:06:31.884 CEST [1196] STATEMENT: EXPLAIN (FORMAT JSON,
ANALYZE false, VERBOSE false, COSTS false, TIMING false, BUFFERS false,
SUMMARY false, SETTINGS false) SELECT COUNT(*) FROM
"domino_efekty_havarijniprojev"
2022-05-09 00:06:39.820 CEST [1196] ERROR: variable not found in subplan
target list
2022-05-09 00:06:39.820 CEST [1196] STATEMENT: EXPLAIN SELECT COUNT(*) FROM
"domino_efekty_havarijniprojev"
Differences against standard config:
shared_buffers = 8192MB
effective_cache_size = 16GB
cursor_tuple_fraction = 1.0