From: | mg <marcel(dot)gsteiger(at)milprog(dot)ch> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Error: 'cache lookup failed' w/trigger |
Date: | 2001-02-20 23:09:56 |
Message-ID: | 3A92F944.6292D871@milprog.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | root | 2001-02-20 23:44:28 | general question |
Previous Message | Marko Kreen | 2001-02-20 23:06:31 | Re: C function woes (more info) |