Horton

Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: torikoshia <torikoshia@oss.nttdata.com>, Peter Eisentraut <peter.eisentraut@enterprisedb.com>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2021-09-15T15:28:28Z
Lists: pgsql-hackers 
Andrew Dunstan <andrew@dunslane.net> writes:
> On 9/10/21 10:10 AM, torikoshia wrote:
>> I've attached the patch for the changes made for this test for your
>> reference, but I'm not sure it's appropriate for creating a new
>> CoercionForm to fix the issue..

> This is listed as an open item for release 14. Is it planned to commit
> the patch? If not, we should close the item.

I do not think that patch is a proper solution, but we do need to do
something about this.

			regards, tom lane

Commits

  1. Fix EXPLAIN of SEARCH BREADTH FIRST queries some more.

  2. Fix EXPLAIN to handle SEARCH BREADTH FIRST queries.

  3. Message style improvements