| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | David Rowley <dgrowleyml(at)gmail(dot)com>, dqetool(at)126(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #18764: server closed the connection unexpectedly |
| Date: | 2025-01-07 07:00:21 |
| Message-ID: | CAMbWs4-Tgw5fKcbzba8UCwXxAE7oTCzc7DXU3BfCS0UPeb4A8Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Sat, Jan 4, 2025 at 2:58 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philippe BEAUDOIN | 2025-01-07 10:32:02 | Re: BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction. |
| Previous Message | lyz | 2025-01-07 03:13:50 | Re: BUG #18763: pg_get_viewdef returns an old def with new relation name |