From: Dmitry Tkach <dmitry@openratings.com>
To: Yudie <yudie@axiontech.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: trigger error
Date: Tue, 10 Jun 2003 11:57:31 -0400
Message-ID: <3EE5FFEB.8090608@openratings.com> (raw)
In-Reply-To: <001b01c32f69$eda57120$8401a8c0@yudie>
References: <001b01c32f69$eda57120$8401a8c0@yudie>
You must have dropped and recreated the function after your trigger was
created...
You need to recreate the trigger now, so that it picks up the new
function id.
In the future use 'CREATE OR REPLACE' to modify a function instead of
DROP and CREATE - this will make sure the modified function keeps its id.
I hope, it helps...
Dima
Yudie wrote:
> Hi,
> I',m trying to create trigger with plpgsql trigger function
> then I got this error message when trigger executed:
>
> Number: -2147467259
> Error while executing th query;
> ERROR: fmgr_info: function 1546856080: cache lookup failed
>
> Here is the function code:
>
> CREATE FUNCTION TRIGGER_UPDATE_AXPRDT_STATUS()
> RETURNS OPAQUE
> AS 'BEGIN
> IF NEW.ONHAND = 0 THEN
> NEW.STATUS = ''D'';
> END IF;
> RETURN NEW;
> END;'
> LANGUAGE 'plpgsql';
>
> CREATE TRIGGER TRIGGER_AXPRDT_FUTURESTATUS
> BEFORE UPDATE ON AXPRDT
> FOR EACH ROW
> EXECUTE PROCEDURE TRIGGER_UPDATE_AXPRDT_STATUS();
>
>
> Please Help..
>
> Yudie
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: dmitry@openratings.com, yudie@axiontech.com
Subject: Re: trigger error
In-Reply-To: <3EE5FFEB.8090608@openratings.com>
* 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