Calling stored procedures.

From: "John Trambakoulos" <jtram98(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Calling stored procedures.
Date: 2001-08-13 14:42:03
Message-ID: 9l8p1b$9dd$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. I've created some stored procedures. For example:

create function validate_user(varchar, varchar)
RETURNS integer AS '
BEGIN
SELECT count(*) INTO ret
FROM users
WHERE userid = $1 and passwd = $2;
RETURN ret;
END;
'
LANGUAGE 'plpgsql';

When I try to call it with the command, select validate_users('user',
passwd'), I get this error message:

Error Number: -2147467259
Error Description: Error while executing the query;
ERROR: fmgr_info: function 19264: cache lookup failed

I did some research and found that this error message occurs when a stored
procedure refers to another function that has been dropped from the database
and that to avoid this error you must drop all objects referring to this
stored procedure and recreate them. The problem is that I get this error
message for NEWLY created procedures? Any ideas about this? I don't know
what this OID 19264 is referring to.

Thanks.

John

Responses

Browse pgsql-general by date

  From Date Subject
Next Message wsheldah 2001-08-13 15:35:38 Re: How can I view the definition of an existing trigger?
Previous Message Patrick Welche 2001-08-13 14:36:35 Re: delete columns from table!