Changed function - Mailing list pgsql-novice

From Reinhard Hnat
Subject Changed function
Date
Msg-id 004701c20b0b$5b3a2c00$0163a8c0@hn
Whole thread Raw
Responses Re: Changed function  (Jon Erickson <jon.erickson@neicoltech.org>)
List pgsql-novice
I have changed a plpgsql function using phpPgAdmin II. When the related
trigger was fired next time i saw the following message:

PostgreSQL said: ERROR: fmgr_info: function 542564: cache lookup failed

the problem seems to be, that the oid of the function has changed. obviously
the trigger remembered the old oid and does not search for the new oid of
the function which name is referenced in the trigger definition. what is to
do to make the changed function useable again? how can the trigger learn to
reference the right function.

Best regards
Reinhard Hnat

hnat@logotronic.co.at


pgsql-novice by date:

Previous
From: "nimeshb"
Date:
Subject: ecpg not found
Next
From: "Guthrie, John"
Date:
Subject: OIDs