plpgsql: Plan type mismatch error - Mailing list pgsql-hackers

From Brendan Jurd
Subject plpgsql: Plan type mismatch error
Date
Msg-id 37ed240d0710152131g55485927s87519a55080c668a@mail.gmail.com
Whole thread Raw
Responses Re: plpgsql: Plan type mismatch error
List pgsql-hackers
Hi hackers,

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.  I'd like to change it to something more like

ERROR: the type of "varname" does not match the type expected by the planner
HINT: Ensure that the type does not change between function calls, or
use EXECUTE instead

Comments?

Regards,
BJ


pgsql-hackers by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: V3 protocol is slower than V2
Next
From: Tom Lane
Date:
Subject: Re: V3 protocol is slower than V2