From: | "Ki won, Song" <schiva(at)m2000(dot)co(dot)kr> |
---|---|
To: | "PostgreSQL-ADMIN" <pgsql-admin(at)postgresql(dot)org> |
Subject: | why trigger not execute?? |
Date: | 1998-12-05 02:37:29 |
Message-ID: | 002001be1ff8$3439b460$4157fbcb@m2000.www.m2000.co.kr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I testing trigger with pl/pgsql...
i face with some error!!
but, i don't know why error occured??
Please, Would you mind help me?
-----------------------------------------------------------
CREATE TABLE t1 (a int4, b text, mtime datetime);
CREATE FUNCTION t1_stamp () RETURNS opaque AS '
BEGIN
new.mtime := ''now'';
RETURN new;
END;
' LANGUAGE 'plpgsql';
CREATE TRIGGER t1_stamp BEFORE INSERT OR UPDATE ON t1
FOR EACH ROW EXECUTE PROCEDURE t1_stamp();
-----------------------------------------------------------
then " insert into t1 (a) values (1); " running....
this error is occured..
error message is "Erro!! fmgr_info: function 90208: cache lookup failed"
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Blair | 1998-12-05 19:58:44 | ERROR - 6.4 pqReadData() error when creating stored procedures |
Previous Message | Oliver Elphick | 1998-12-04 13:45:21 | Re: [ADMIN] Problems with upgrading 6.3.1 to 6.4 |