Re: Error passing parameter to functions

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?

Best regards

Jose Luis

> -----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'
not
> > 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
your
> 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