Meanwhile, I've found the source of my problem myself. When I drop a function and re-create it (this is what phpPgAdmin does when "modifying" a function), I also have to drop and re-create the corresponding trigger. Again one of these 'gotchas' for beginners... mg schrieb: > 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