Hello, I'm new to Postgresql and just tried to write my very first pgsql trigger procedure. So please forgive me if this is a stupid question. This is what I did: 1. using bash as user postgres (my db superuser) on my RH6.2 linux box: bash$ export PGLIB=/usr/lib/pgsql bash$ createlang plpgsql mydb 2. using phpPgAdmin, I then could create the following procedure: CREATE FUNCTION "datetimestamp"() RETURNS OPAQUE AS 'BEGIN NEW.modificationdatetime := \'now\' END;' LANGUAGE 'plpgsql' 3. Then I created a trigger: CREATE TRIGGER "accounts_datetimestamp" BEFORE INSERT OR UPDATE ON "accounts" FOR EACH ROW EXECUTE PROCEDURE datetimestamp(); Now everytime I try to update something in my accounts table I get the message: ERROR: fmgr_info: function 51232: cache lookup failed What's wrong here? BTW: is there a source for trigger procedure examples? These trigger procedures could help me solve a lot of problems. Thanks for any suggestions Greetings from switzerland --Marcel
