#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Posts
    373
    Rep Power
    11

    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???
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Posts
    373
    Rep Power
    11
    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.

IMN logo majestic logo threadwatch logo seochat tools logo