Re: Support prepared statement invalidation when result types change - Mailing list pgsql-hackers

From Jelte Fennema
Subject Re: Support prepared statement invalidation when result types change
Date
Msg-id CAGECzQQnm2Tdq9_EJRDL-HVEGcbEmpqADxXJ=p5zVXheu1=8-g@mail.gmail.com
Whole thread Raw
In response to Re: Support prepared statement invalidation when result types change  (jian he <jian.universality@gmail.com>)
Responses Re: Support prepared statement invalidation when result types change
List pgsql-hackers
On Mon, 28 Aug 2023 at 11:27, jian he <jian.universality@gmail.com> wrote:
> With parameters, it also works, only a tiny issue with error reporting.
>
> prepstmt2 | PREPARE prepstmt2(bigint) AS SELECT * FROM pcachetest
> WHERE q1 = $1; | {bigint}        | {bigint,bigint,bigint}
> ERROR:  column "q1" does not exist at character 61
> HINT:  Perhaps you meant to reference the column "pcachetest.x1".
> STATEMENT:  execute prepstmt2(1);
>
> I think "character 61" refer to "PREPARE prepstmt2(bigint) AS SELECT *
> FROM pcachetest WHERE q1 = $1;"
> so maybe the STATEMENT is slightly misleading.

Could you share the full set of commands that cause the reporting
issue? I don't think my changes should impact this reporting, so I'm
curious if this is a new issue, or an already existing one.



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Eager page freeze criteria clarification
Next
From: Sergey Shinderuk
Date:
Subject: Re: Fix error handling in be_tls_open_server()