Postgres Pro
Downloads
Home   >   mailing lists

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

From Jean Landercy - BEEODIVERSITY
Subject RE: Sudden database error with COUNT(*) making Query Planner crashes: variable not found in subplan target list
Date
Msg-id VI1PR09MB4382C2C3D58DD75598A82D34E7A29@VI1PR09MB4382.eurprd09.prod.outlook.com
Whole thread Raw
In response to Re: Sudden database error with COUNT(*) making Query Planner crashes: variable not found in subplan target list  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: Sudden database error with COUNT(*) making Query Planner crashes: variable not found in subplan target list
List pgsql-hackers
Tree view 
Dear Justin,

Thank you for your quick reply.
Unfortunately, the server having this issue is an Azure Flexible Server.
Upgrades are managed by Azure, I will have to wait until they release the version 13.7.

Is there a procedure to replicate the database and preserve the bug.
My attempts with pg_dump/psql failed (the bug vanishes).
If so then I can clone the faulty database and upgrade it on a newer version.

Best regards,

Landercy Jean

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: pg_buffercache: add sql test
Next
From: Robert Haas
Date:
Subject: Re: How about a psql backslash command to show GUCs?