From: | "Iain" <iain(at)mst(dot)co(dot)jp> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | fmgr_info: function 15238119: cache lookup failed |
Date: | 2003-11-20 02:37:33 |
Message-ID: | 004101c3af0f$40653290$7201a8c0@mst1x5r347kymb |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi All,
I have a problem with a before update trigger that I was wondering if
someone might be able to give me some help with.
DB version is 7.2. Here is a cut down version of an already simple trigger
and function that is returning the error:
fmgr_info: function 15238119: cache lookup failed
CREATE FUNCTION f_hatyuu_detail( ) RETURNS opaque AS '
BEGIN
raise notice ''f_hatyuu_detail started TG_WHEN= % TG_OP= %'',TG_WHEN,
TG_OP;
if TG_WHEN <> ''BEFORE'' or TG_OP <> ''UPDATE'' then
return null;
end if;
raise notice ''debug 3'';
return new;
raise notice ''debug 4'';
END;
' LANGUAGE 'plpgsql';
drop trigger TG_D_HATYUU_DETAIL_B on D_HATYUU_DETAIL;
create trigger TG_D_HATYUU_DETAIL_B BEFORE update on D_HATYUU_DETAIL for
each row
execute procedure f_hatyuu_detail();
When I do an UPDATE against the table, I get the abovementioned error on the
RETURN NEW; The debug 4 message is not displayed. If I return NULL it
operates as expected (0 rows updated). Did I miss something here?
regards
Iain
From | Date | Subject | |
---|---|---|---|
Next Message | Iain | 2003-11-20 02:53:04 | Re: fmgr_info: function 15238119: cache lookup failed |
Previous Message | Stephan Szabo | 2003-11-19 20:42:31 | Re: Substrings by Regular Expression |