November 13th, 2003, 03:02 PM
SQLError thrown from java program
I am running a java program that is connected via JDBC. I know the connection works fine, and most transactions work fine, but when I run this one update, it makes this error:
ERROR: fmgr_info: function 4516725: cache lookup failed
Now, if I issue the query seperately in psql, it still comes back with the same error. There are plpgsql functions that are run when this table is updated. Could these be at fault if they return multiple records or something? What is this error from???
November 13th, 2003, 03:45 PM
Aargh, I need to stop being so good at finding the answers to my own questions...
fmgr_info: function <number>: cache lookup failed
By Jan Wieck : This happens when you have dropped a function which was referenced by another object (view, operator, aggregate, whatnot). Recreating the function doesn't help, because functions are referenced by OID. You have to drop and recreate all dependant objects as well.