Thanks a lot Tom,
This was exactly the problem. I was going crazy thinking it was an
error in my code. Is this a bug in postgresql?
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: martes, 05 de marzo de 2002 17:04
> To: Jose Luis LG
> Cc: pgsql-interfaces(at)postgresql(dot)org
> Subject: Re: [INTERFACES] Error passing parameter to functions
> "Jose Luis LG" <jlopezgonz(at)terra(dot)es> writes:
> > If I send the themeID as above I get: ERROR: Attribute 'mathematics'
> > found.
> As expected.
> > If I send the themeID = "'mathematics'" I get: fmgr_info: function
> > 24907: cache lookup failed.
> The query syntax is now correct, but there's something broken about
> function definition. My bet is that the plpgsql call handler function
> has been deleted. Try reinstalling plpgsql --- ie, rerun createlang;
> and then recreate your function, since it'll still be pointing at the
> old plpgsql OID.
> regards, tom lane
In response to
pgsql-interfaces by date
|Next:||From: Jose Luis LG||Date: 2002-03-06 09:35:19|
|Subject: Re: Error passing parameter to functions |
|Previous:||From: Jim Parker||Date: 2002-03-05 23:08:22|
|Subject: Linking ECPG files to a C program|