|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
November 13th, 2003, 04: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???
|
|
#2
November 13th, 2003, 04: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.
|
|
| Viewing: Dev Shed Forums > Databases > PostgreSQL Help > SQLError thrown from java program |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
