Re: cache lookup failed

On Fri, Oct 13, 2000 at 09:17:36AM +0200, Fabrice Pollet wrote:
: After create function and trigger, when I update "fams" by delete entry in
: table "indi" I get this message :
:
: ERROR: fmgr_info: function 19968: cache lookup failed

Hi,

I recently struggled with the same error message and found out
that it occured when you define a trigger which uses a function,
drop the function and redefine it. The trigger in that case still
points to some undefined space...

I'm not sure whether I call this a bug or whether this is normal
behaviour in RDBMS's. I would expect these pointers to be based on
names but maybe thats not possible ?

Regards

--
+-----------------------------------------------------------------------+
| Henk van Lingen, Systems Administrator, <henkvl(at)cs(dot)uu(dot)nl> |
| Dept. of Computer Science, Utrecht University. phone: +31-30-2535278 |
+--------------------- http://henk.vanlingen.net/ ----------------------+