RE: Sudden database error with COUNT(*) making Query Planner crashes: variable not found in subplan target list

Dear David,

Thank you for taking time on this issue.

Here is the detail of the table (I have anonymized it on SO, this is its real name):

\d logistic_site
Table « public.logistic_site »
Colonne | Type | Collationnement | NULL-able | Par défaut

-------------+--------------------------+-----------------+-----------+-------------------------------------------
id | bigint | | not null | nextval('logistic_site_id_seq'::regclass)
key | character varying(32) | | not null |
name | character varying(128) | | |
created | timestamp with time zone | | not null |
updated | timestamp with time zone | | not null |
archived | timestamp with time zone | | |
geom | geometry(Polygon,4326) | | |
location | geometry(Point,4326) | | |
notes | text | | |
country_id | bigint | | |
customer_id | bigint | | |

Index :
"logistic_site_pkey" PRIMARY KEY, btree (id)
"logistic_site_country_id_9a696481" btree (country_id)
"logistic_site_customer_id_a2c8a74a" btree (customer_id)
"logistic_site_geom_105a08da_id" gist (geom)
"logistic_site_key_2e791173_like" btree (key varchar_pattern_ops)
"logistic_site_key_key" UNIQUE CONSTRAINT, btree (key)
"logistic_site_location_54ae0166_id" gist (location)
Contraintes de clés étrangères :
"logistic_site_country_id_9a696481_fk_logistic_country_id" FOREIGN KEY (country_id) REFERENCES logistic_country(id) DEFERRABLE INITIALLY DEFERRED
"logistic_site_customer_id_a2c8a74a_fk_logistic_customer_id" FOREIGN KEY (customer_id) REFERENCES logistic_customer(id) DEFERRABLE INITIALLY DEFERRED
Référencé par :
TABLE "logistic_hive" CONSTRAINT "logistic_hive_site_id_50c29dd8_fk_logistic_site_id" FOREIGN KEY (site_id) REFERENCES logistic_site(id) DEFERRABLE INITIALLY DEFERRED
TABLE "logistic_packorder" CONSTRAINT "logistic_packorder_site_id_16e1a41a_fk_logistic_site_id" FOREIGN KEY (site_id) REFERENCES logistic_site(id) DEFERRABLE INITIALLY DEFERRED
TABLE "logistic_projectsite" CONSTRAINT "logistic_projectsite_site_id_522bf74b_fk_logistic_site_id" FOREIGN KEY (site_id) REFERENCES logistic_site(id) DEFERRABLE INITIALLY DEFERRED
TABLE "scientific_identification" CONSTRAINT "scientific_identification_site_id_d9e79149_fk_logistic_site_id" FOREIGN KEY (site_id) REFERENCES logistic_site(id) DEFERRABLE INITIALLY DEFERRED
TABLE "scientific_inventory" CONSTRAINT "scientific_inventory_site_id_72521353_fk_logistic_site_id" FOREIGN KEY (site_id) REFERENCES logistic_site(id) DEFERRABLE INITIALLY DEFERRED
TABLE "scientific_result" CONSTRAINT "scientific_result_site_id_af6c815d_fk_logistic_site_id" FOREIGN KEY (site_id) REFERENCES logistic_site(id) DEFERRABLE INITIALLY DEFERRED
TABLE "scientific_selection" CONSTRAINT "scientific_selection_site_id_88d69cab_fk_logistic_site_id" FOREIGN KEY (site_id) REFERENCES logistic_site(id) DEFERRABLE INITIALLY DEFERRED

And the output of the related query:

SELECT
attname, atttypid::regtype, attnum,atthasdef, atthasmissing, attgenerated, attisdropped
FROM
pg_attribute
WHERE
attrelid = 'logistic_site'::regclass
ORDER BY
attnum;

attname | atttypid | attnum | atthasdef | atthasmissing | attgenerated | attisdropped
-------------+--------------------------+--------+-----------+---------------+--------------+--------------
tableoid | oid | -6 | f | f | | f
cmax | cid | -5 | f | f | | f
xmax | xid | -4 | f | f | | f
cmin | cid | -3 | f | f | | f
xmin | xid | -2 | f | f | | f
ctid | tid | -1 | f | f | | f
id | bigint | 1 | t | f | | f
key | character varying | 2 | f | f | | f
name | character varying | 3 | f | f | | f
created | timestamp with time zone | 4 | f | f | | f
updated | timestamp with time zone | 5 | f | f | | f
archived | timestamp with time zone | 6 | f | f | | f
geom | geometry | 7 | f | f | | f
location | geometry | 8 | f | f | | f
notes | text | 9 | f | f | | f
country_id | bigint | 10 | f | f | | f
customer_id | bigint | 11 | f | f | | f
(17 lignes)

Additional information:
When trying to read the SQL related query for this table in PgAdmin4 I also have the error message popping up and the I get no SQL. So maybe the problem resides in a deeper function the Query Planner and SQL generator functions rely on.

Don't hesitate to ask for more information.

Best regards,

Jean