Re: plpgsql: Plan type mismatch error

On 10/16/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Brendan Jurd" <direvus(at)gmail(dot)com> writes:
> > I recently ran afoul of the following error message:
> > ERROR: type of "varname" does not match that when preparing the plan
> > IMO the message isn't quite in English and doesn't explain the problem
> > very well.
>
> The English is fine. What I want to know about is whether this was a
> current release, and if so how you provoked it.

This was in 8.3 beta 1. I provoked the message by having a variable
which came from a dynamic query (EXECUTE .. INTO a variable of type
RECORD), and a member of that record changed type between one
execution of the function and the next.

So the plan was cached on the first execution, and in the second
execution the type of the variable did not match the type in the plan.
At least, that's what I understand happened from looking at the code
which emitted the message.

Once I knew what the message was talking about, fixing my function was
easy. It's a useful error message, it's just not well articulated ...

Cheers,
BJ