cache lookup error when excuting function
От | chris Günther |
---|---|
Тема | cache lookup error when excuting function |
Дата | |
Msg-id | 20010102130733.2a2a73f6.guenther@uscreen.de обсуждение исходный текст |
Список | 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
В списке pgsql-novice по дате отправления: