ERROR: fmgr_info: function 24126: cache lookup failed

From: "Guilherme Silva" <guisilva(at)infosites(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: fmgr_info: function 24126: cache lookup failed
Date: 2002-09-27 18:19:46
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAchv9IrPe1RGyqQAwTwTX38KAAAAQAAAAwuXE856fm0WIwaMCtFYXwQEAAAAA@infosites.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.
Even after reading many messages in this list, I still have this
problem, so I ask for help. In this case, recreating the trigger didn't
fix the problem.

I have to timestamp records on every update or insert. I did the
following steps in this order:
1) created this table:
CREATE TABLE "tb_cargo" (
"id_cargo" int4 DEFAULT nextval('"sqnc_cargo"'::text) NOT NULL,
"id_familiacargo" int4 NOT NULL,
"ds_cargo" varchar(40) NOT NULL,
"dt_alteracao" timestamp,
CONSTRAINT "PK_cargo" PRIMARY KEY ("id_cargo")
);

2) created this function:
CREATE FUNCTION "atualizadtalteracaorefs"() RETURNS OPAQUE AS 'begin
NEW.dt_alteracao:=CURRENT_TIMESTAMP;
return NEW;
end;
' LANGUAGE 'plpgsql'
The table

3) created this trigger:
CREATE TRIGGER "ta_tb_cargo" BEFORE INSERT OR UPDATE ON "tb_cargo " FOR
EACH ROW EXECUTE PROCEDURE atualizadtalteracaorefs();

4) tried to insert data
ERROR: fmgr_info: function 24126: cache lookup failed

Guilherme Silva

Browse pgsql-general by date

  From Date Subject
Next Message Barry Lind 2002-09-27 18:24:39 Re: [JDBC] Prepared statement performance...
Previous Message Weaver, Walt 2002-09-27 17:56:42 Re: Hey, where is Python.h ???