cache lookup error when excuting function

Поиск
Список
Период
Сортировка
Искать
От
chris Günther
Тема
cache lookup error when excuting function
Дата
Msg-id
20010102130733.2a2a73f6.guenther@uscreen.de
Список
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 по дате отправления
От: Huy Do
Дата:
От: Alan Young
Дата:
FAQ