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>
Subject: Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails
In-reply-to: <24ce73f9-c714-9a7c-6cc0-34e724c8f1c9@dunslane.net>
References: <5bafa66ad529e11860339565c9e7c166@oss.nttdata.com>
 <3208199.1631039493@sss.pgh.pa.us>
 <b6fecc71-60b9-bd44-4b78-f2a9dd74f46f@enterprisedb.com>
 <d70fa4dfd333b1de1024e50c2ad1a6ea@oss.nttdata.com>
 <24ce73f9-c714-9a7c-6cc0-34e724c8f1c9@dunslane.net>
Comments: In-reply-to Andrew Dunstan <andrew@dunslane.net>
	message dated "Wed, 15 Sep 2021 11:05:02 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <984393.1631719708.1@sss.pgh.pa.us>
Date: Wed, 15 Sep 2021 11:28:28 -0400
Message-ID: <984394.1631719708@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/984394.1631719708%40sss.pgh.pa.us>
Precedence: bulk

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