Help! Error when calling a function

From: "Ben Schneider" <bschneider(at)microdynamics(dot)cc>
To: "Postgres Admin List" <pgsql-admin(at)postgresql(dot)org>
Subject: Help! Error when calling a function
Date: 2003-06-06 20:12:50
Message-ID: 000001c32c68$05a00560$5011a8c0@micronpc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am receiving the following error when I call a simple function:

Warning: pg_exec() [function.pg-exec <http://www.php.net/function.pg-exec>
]: Query failed: ERROR: fmgr_info: function 3036754: cache lookup failed .
in /var/www/html/cmwareben/db_pgsql.php on line 93
Database error: Invalid SQL: SELECT note_num,
fn_concat(rtrim(substring(note,0,40)), '...') AS note FROM feedback_notes
ORDER BY note_num
PostgreSQL Error: 1 (ERROR: fmgr_info: function 3036754: cache lookup failed
)
Session halted.

Here is the fn_concat function that I am calling

CREATE FUNCTION "fn_concat"(text, text) RETURNS text AS 'begin
return $1 || $2;
end;' LANGUAGE 'plpgsql'

I have the same function in another DB on the same server and it is working
fine. The only change I made to the DB was to drop the feedback_notes table
and recreate it with an additional column (New column = 'status'). The
select was working before I made this change and now it doesn't. No changes
were made to my PHP scripts at all! I hadn't don't even call the new column
in my select.

What the heck happened?

Ben

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jonathan Gardner 2003-06-06 21:11:21 Re: Urgent: Restoring many schemas in a database
Previous Message Shankar K 2003-06-06 17:07:41 Re: interpret vacuum verbose output