Horton

Re: BUG #18764: server closed the connection unexpectedly

Richard Guo <guofenglinux@gmail.com>

View thread
From: Richard Guo <guofenglinux@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: David Rowley <dgrowleyml@gmail.com>, dqetool@126.com, pgsql-bugs@lists.postgresql.org
Date: 2025-01-07T07:00:21Z
Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Fix UNION planner datatype issue

  2. Allow planner to use Merge Append to efficiently implement UNION

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