Skip site navigation (1) Skip section navigation (2)

Re: Error passing parameter to functions

From: "Jose Luis LG" <jlopezgonz(at)terra(dot)es>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Error passing parameter to functions
Date: 2002-03-06 09:35:19
Message-ID: 00f601c1c4f2$3b7c34d0$424d4d7d@Servidor2K.local (view raw or flat)
Thread:
Lists: 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(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


In response to

pgsql-interfaces by date

Next:From: Antonio Sergio de Mello e SouzaDate: 2002-03-06 13:39:42
Subject: Re: Linking ECPG files to a C program
Previous:From: Jose Luis LGDate: 2002-03-06 09:32:08
Subject: Re: Error passing parameter to functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group