pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Iain <iain@mst.co.jp>
To: pgsql-sql@postgresql.org
Subject: fmgr_info: function 15238119: cache lookup failed
Date: Thu, 20 Nov 2003 11:37:33 +0900
Message-ID: <004101c3af0f$40653290$7201a8c0@mst1x5r347kymb> (raw)

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

view thread (2+ messages)  latest in thread

Message-ID: <004101c3af0f$40653290$7201a8c0@mst1x5r347kymb>
Permalink:  ../004101c3af0f$40653290$7201a8c0@mst1x5r347kymb/
Also on:    postgresql.org/message-id/004101c3af0f$40653290$7201a8c0@mst1x5r347kymb

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: iain@mst.co.jp
  Subject: Re: fmgr_info: function 15238119: cache lookup failed
  In-Reply-To: <004101c3af0f$40653290$7201a8c0@mst1x5r347kymb>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox