Re: BUG #15109: Unhelpful error message on type mismatch - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15109: Unhelpful error message on type mismatch
Date
Msg-id 7087.1520980596@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #15109: Unhelpful error message on type mismatch  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tue, Mar 13, 2018 at 1:46 PM, PG Bug reporting form <
> noreply@postgresql.org> wrote:
>> psql:xxx.sql:19: ERROR:  type of parameter 4 (bigint) does not match that
>> when preparing the plan (text)
>> CONTEXT:  PL/pgSQL function xxx(boolean) line 12 at RETURN

> In short - this isn't a bug report so this isn't the right list for the
> discussion (that would be -general), and while the frustration is real the
> proposed alternatives do not seem realistic.

Ideally, of course, we'd like to not see this error at all, at least not
in the context of plpgsql --- it should auto-replan affected statements
when a record column changes type.  That's been on the to-do list for a
long time, though, and hasn't gotten done.  When it does get done it's
unlikely to be something we'd risk back-patching.

So you could call this a bug if you want, but when it does get fixed
it'll be treated as a new feature instead.

            regards, tom lane


pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #15109: Unhelpful error message on type mismatch
Next
From: Michael Meskes
Date:
Subject: Re: BUG #15104: Double free in the main function in ecpg.c