Re: BUG #18576: Using EXPLAIN (VERBOSE) in information_schema.element_types returns ERROR: failed to find plan for - Mailing list pgsql-bugs

From Andrei Lepikhov
Subject Re: BUG #18576: Using EXPLAIN (VERBOSE) in information_schema.element_types returns ERROR: failed to find plan for
Date
Msg-id 7f8bfe01-bc5f-4a93-bcd6-b06e7c24f804@gmail.com
Whole thread Raw
In response to Re: BUG #18576: Using EXPLAIN (VERBOSE) in information_schema.element_types returns ERROR: failed to find plan for  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #18576: Using EXPLAIN (VERBOSE) in information_schema.element_types returns ERROR: failed to find plan for
List pgsql-bugs
On 19/8/2024 19:26, Tom Lane wrote:
> Andrei Lepikhov <lepihov@gmail.com> writes:
>> On 19/8/2024 18:36, Tom Lane wrote:
>>> This seems like it's making assumptions it shouldn't about what
>>> CustomScan does.  If there's an argument for doing this, it should
>>> be added to the adjacent comments.
> The main reason I'm being sticky about this is that if we need to
> allow CustomScan, then it seems likely that we also need to allow
> ForeignScan, and maybe some other things, and then I start to
> wonder if we should have any assertion at all about the child
> plan type.  So I want to actually understand what is the scenario
> in which this will happen.
I understand your point — the origins of ForeignScan and CustomScan are 
the same.
However, we also have a difference: CustomScan can be executed locally 
and sometimes may allow volatile functions, CTE, and many other things 
in the underlying subtree. That's why we can't replay some cases with 
ForeignScan stuff.
But ok, it make sense. I'll try to reproduce the case by employing 
ForeignScan.

-- 
regards, Andrei Lepikhov




pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18576: Using EXPLAIN (VERBOSE) in information_schema.element_types returns ERROR: failed to find plan for
Next
From: Matthew Clark
Date:
Subject: server crash on raspberry pi for large queries