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
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 |