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

Re: Error passing parameter to functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jose Luis LG" <jlopezgonz(at)terra(dot)es>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Error passing parameter to functions
Date: 2002-03-05 16:03:57
Message-ID: 15809.1015344237@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
"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

Responses

pgsql-interfaces by date

Next:From: Hubert PalmeDate: 2002-03-05 20:33:44
Subject: Re: PL/pgSQL Syntax Problem
Previous:From: Ashley ClarkDate: 2002-03-05 15:49:28
Subject: Re: PL/pgSQL Syntax Problem

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