[HACKERS] plpgsql: Plan type mismatch error

2007-10-15 Thread Brendan Jurd
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

Re: [HACKERS] plpgsql: Plan type mismatch error

2007-10-15 Thread Tom Lane
Brendan Jurd [EMAIL PROTECTED] 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

Re: [HACKERS] plpgsql: Plan type mismatch error

2007-10-15 Thread Brendan Jurd
On 10/16/07, Tom Lane [EMAIL PROTECTED] wrote: Brendan Jurd [EMAIL PROTECTED] 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.

Re: [HACKERS] plpgsql: Plan type mismatch error

2007-10-15 Thread Pavel Stehule
2007/10/16, Brendan Jurd [EMAIL PROTECTED]: On 10/16/07, Tom Lane [EMAIL PROTECTED] wrote: Brendan Jurd [EMAIL PROTECTED] 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

Re: [HACKERS] plpgsql: Plan type mismatch error

2007-10-15 Thread Brendan Jurd
On 10/16/07, Pavel Stehule [EMAIL PROTECTED] wrote: please, read: http://www.pgsql.cz/index.php/Automatic_execution_plan_caching_in_PL/pgSQL Thanks Pavel, I actually came across that wiki article via Google when I was first trying to learn more about the message. But, I'm not asking for help