Hi,
I have Postgres 7.3.2 running on a Mandrake Linux 9.0 box. I have a series a defined tables and two stored procedures defined in a database.
I have some java code that makes a remote connection and will call the stored procedures and insert the returned values along with data through the jdbc connection.
Whenever I do an insert I will get messages such as:
ERROR: Relation "image" does not exist
where image is one of several tables.
I get the following message concerning the stored procedures:
ERROR: Function get_next_local_id(integer) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
This is but one of two stored procedures. This one is called before the other one so I will suspect that even if the first one is called correctly the second one will suffer the same fate.
If I manually connect to the database using psql, all of the tables and the stored procedures exist. All table have the proper permissions for the connecting user from my java app to select,insert,append,delete row entries from the tables.
I have granted executable privileges for the connecting user on the stored procedure.
Is there anything else I am missing or should be checking for?
I did have all of this running on a SPARC system running 7.1.2, for what it’s worth.
Thanks in advance,
-Bill Thomason