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@sss.pgh.pa.us]
> Sent: martes, 05 de marzo de 2002 17:04
> To: Jose Luis LG
> Cc: pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] Error passing parameter to functions
>
> "Jose Luis LG" <jlopezgonz@terra.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
