Re: BUG #18764: server closed the connection unexpectedly - Mailing list pgsql-bugs

From Richard Guo
Subject Re: BUG #18764: server closed the connection unexpectedly
Date
Msg-id CAMbWs4-Tgw5fKcbzba8UCwXxAE7oTCzc7DXU3BfCS0UPeb4A8Q@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18764: server closed the connection unexpectedly  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Sat, Jan 4, 2025 at 2:58 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Also, I've confirmed by looking at the plan tree that the implicit
> cast of c1 from integer to numeric is done in the targetlist of
> the Subquery Scan node.  (I'm surprised that EXPLAIN VERBOSE hides
> that function call; it's not very helpful that it does so.)

Yeah, it seems that we tend to hide function calls that are implicit
casts.  show_plan_tlist() calls deparse_expression() with showimplicit
set to false, and get_func_expr() does not display function calls of
COERCE_IMPLICIT_CAST in this case.

Thanks
Richard



pgsql-bugs by date:

Previous
From: lyz
Date:
Subject: Re: BUG #18763: pg_get_viewdef returns an old def with new relation name
Next
From: Philippe BEAUDOIN
Date:
Subject: Re: BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction.