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@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