SQL Exception Relation xxx does not exist

From: Alex <alex(at)meerkatsoft(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: SQL Exception Relation xxx does not exist
Date: 2004-01-20 05:00:43
Message-ID: 400CB5FB.4030503@meerkatsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers

Hi,
I am getting the following error when running an update from a JAVA
program using a Tomcat Connection Pool.

SQLException: Error Relation 215106760 does not exist

In the server log I see additional info Error occured while executing
PL/pgSQL function funcName
line 105 at select into variables

I dont think that the Function has a problem as I am able to run it with
the same parameters from within psql returning me a result.

The strange thing is that it works for a couple of day. Once I restart
tomcat the problem goes away... for a few days. Although I use many
objects from the same Servlet, only this particular PL/pgSQL function
has a problem.

Question:
1. Is that problem known in PG7.3.4?
2. Could this be a problem with the connection pool of tomcat or the
postgres JDBC driver ?
3. how do i find out the name of the actual object referred by 215106760
in the error message?

Thanks for any help

Alex

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Kris Jurka 2004-01-20 05:16:32 Re: SQL Exception Relation xxx does not exist
Previous Message Bruce Momjian 2004-01-20 03:50:01 Re: Organizing the OSCON presence

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2004-01-20 05:16:32 Re: SQL Exception Relation xxx does not exist
Previous Message Aurangzeb M. Agha 2004-01-20 04:48:49 Re: no space left on device

Browse pgsql-hackers by date

  From Date Subject
Next Message Kris Jurka 2004-01-20 05:16:32 Re: SQL Exception Relation xxx does not exist
Previous Message Matthew T. O'Connor 2004-01-20 03:38:22 Re: VACUUM delay (was Re: What's planned for 7.5?)