plpgsql: Plan type mismatch error

From: "Brendan Jurd" <direvus(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: plpgsql: Plan type mismatch error
Date: 2007-10-16 04:31:32
Message-ID: 37ed240d0710152131g55485927s87519a55080c668a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-10-16 04:45:37 Re: V3 protocol is slower than V2
Previous Message ITAGAKI Takahiro 2007-10-16 04:04:28 V3 protocol is slower than V2