Quick Links

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

From:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
To:	Jean Landercy - BEEODIVERSITY <jean(dot)landercy(at)beeodiversity(dot)com>
Cc:	pgsql-hackers(at)lists(dot)postgresql(dot)org, andersk(at)mit(dot)edu
Subject:	Re: Sudden database error with COUNT(*) making Query Planner crashes: variable not found in subplan target list
Date:	2022-06-06 14:20:44
Message-ID:	20220606142043.GW29853@telsasoft.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

On Mon, Jun 06, 2022 at 09:34:24AM +0000, Jean Landercy - BEEODIVERSITY wrote:
> Faulty setup is about:
>
> SELECT version();
>
> -- PostgreSQL 13.6 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit

Please check if the problem occurs in v13.7

https://www.postgresql.org/message-id/2197859.1644623850@sss.pgh.pa.us
https://www.postgresql.org/message-id/flat/2121219.1644607692%40sss.pgh.pa.us#190c43702a91dbd0509ba545dbbab58d

In response to

Sudden database error with COUNT(*) making Query Planner crashes: variable not found in subplan target list at 2022-06-06 09:34:24 from Jean Landercy - BEEODIVERSITY

Responses

RE: Sudden database error with COUNT(*) making Query Planner crashes: variable not found in subplan target list at 2022-06-06 16:50:55 from Jean Landercy - BEEODIVERSITY

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Jakub Wartak	2022-06-06 14:27:06	RE: pgcon unconference / impact of block size on performance
Previous Message	Justin Pryzby	2022-06-06 13:55:29	Re: How about a psql backslash command to show GUCs?