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

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

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

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 a