Re: a trigger question

On Thu, 6 Jun 2002, pblunat wrote:

> Hi,
> i have a problem with "cache lookup failled" when an insert is made in a
> table with a trigger.
> Error message is : "ERROR : fmgr_info : function 16586 : cache lookup
> failed"
> Quest.: where this problem is ?
> and where the documentation is on this subject ?.

The problem would seem to be that your trigger is using a function that has
been dropped and then possibly recreated.

I've not seen this error myself but I think the solution is to drop the trigger
and recreate it once you are certain the function exists. That's right isn't it
folks? As to the documentation, I don't know a direct link but the main site
http://www.postresql.org/ can lead you through to several places for
documentation. There should be answers to this question in the list archive and
I expect in the FAQ as well.

>
> I made :
> GRANT ALL PRIVILEGES ON all table and trigger,
> trigger is a very simple program for cut string (OK when stand alone).

The GRANT is irrelevent I think. Perhaps you could post a summary of your
schema, the trigger a function(s) if you are still having problems. The version
of postgres you are using would be useful as well.

>
> I am so sorry but beginers in english + beg. in trigger proc. + project'
> stress = problem.

No problem, it's a lot better than my French,

--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants