From: | Miloš Urbánek <milos(dot)urbanek(at)email(dot)cz> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) |
Date: | 2022-05-09 08:59:06 |
Message-ID: | 620.wBLx.mpsJ89z3rK.1YUDVQ@scif.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
When I set:
enable_bitmapscan = off
enable_seqscan = off
I can reproduce the problem. The table has 42 columns. Seems like https://
www.postgresql.org/message-id/2121219.1644607692%40sss.pgh.pa.us
I will wait for 9.3 and give it a try.
--
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
"
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2022-05-09 09:50:18 | Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) |
Previous Message | Miloš Urbánek | 2022-05-09 08:52:47 | Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*) |