BUG #18576: Using EXPLAIN (VERBOSE) in information_schema.element_types returns ERROR: failed to find plan for

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: vasiliy(dot)boytsov(at)gmail(dot)com
Subject: BUG #18576: Using EXPLAIN (VERBOSE) in information_schema.element_types returns ERROR: failed to find plan for
Date: 2024-08-07 15:48:01
Message-ID: 18576-9feac34e132fea9e@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18576
Logged by: Vasya B
Email address: vasiliy(dot)boytsov(at)gmail(dot)com
PostgreSQL version: 16.3
Operating system: Ubuntu 24.04
Description:

From a clean DB, one can execute:
EXPLAIN (VERBOSE) SELECT FROM information_schema.element_types WHERE
object_type = 'TABLE';
Which returns:
ERROR: failed to find plan for subquery ss
While the expected result was a working query.
W/O VERBOSE this query works.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2024-08-07 16:55:47 Re: BUG #18574: procedure cache does not invalidate when output parameter type mismatch
Previous Message jian he 2024-08-07 15:04:08 Re: BUG #18568: BUG: Result wrong when do group by on partition table!