Re: Error passing parameter to functions - Mailing list pgsql-interfaces

From Jose Luis LG
Subject Re: Error passing parameter to functions
Date
Msg-id 00f601c1c4f2$3b7c34d0$424d4d7d@Servidor2K.local
Whole thread Raw
In response to Re: Error passing parameter to functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
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



pgsql-interfaces by date:

Previous
From: "Jose Luis LG"
Date:
Subject: Re: Error passing parameter to functions
Next
From: Antonio Sergio de Mello e Souza
Date:
Subject: Re: Linking ECPG files to a C program