From: | chris Gnther <guenther(at)uscreen(dot)de> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | cache lookup error when excuting function |
Date: | 2001-01-02 12:07:33 |
Message-ID: | 20010102130733.2a2a73f6.guenther@uscreen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi folks,
first I want to say thank you to all the people given me tips on
how to get triggers start a function - you where very helpfull.
But now I have another problem which I don't understand at all. I
created a function in plpgsql which sets my current date, time
and user. It looks as follows:
CREATE FUNCTION fncdatetime_ains() returns opaque as
'begin
new.TimeStamp := now;
new.C_Date := date;
new.C_Time := date;
new.C_User := getpgusername
end if;
return new;
end;'
language 'plpgsql' \g
Then I created a trigger on a table executing this function on insert:
CREATE TRIGGER trgInsServer after insert on tblserver
for each row execute procedure fncdatetime_ains() \g
Now when I do an insert into my table from a website (using php4 pl01)
I get the following error:
PostgreSQL query failed: ERROR: fmgr_info: function 69056: cache lookup failed
What does this mean???
Please all, can you help me again, this is quite important for my project
chris
From | Date | Subject | |
---|---|---|---|
Next Message | Alan Young | 2001-01-02 16:38:52 | Question on setting up trigger. |
Previous Message | Boris | 2001-01-02 04:02:39 | Re[2]: Blob question -((( |