cache lookup error when excuting function - Mailing list pgsql-novice

From chris Günther
Subject cache lookup error when excuting function
Date
Msg-id 20010102130733.2a2a73f6.guenther@uscreen.de
Whole thread Raw
List 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 by date:

Previous
From: "Huy Do"
Date:
Subject: Turn off referential checks for bulk copy
Next
From: Alan Young
Date:
Subject: Question on setting up trigger.