Re: SQL Exception Relation xxx does not exist

On Tue, 20 Jan 2004, Alex wrote:

> 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

This error is likely the result of using a temp table without EXECUTE or
having one of your tables dropped (recreating it won't help).  plpgsql
caches query plans, but doesn't track the plans dependencies, so if any of
the underlying objects change you can get this error.

> 2. Could this be a problem with the connection pool of tomcat or the
> postgres JDBC driver ?

The plans are cached once per backend, the connection pool keeps that same
backend open forever which means you can never safely change your
schema without restarting the pool.

> 3. how do i find out the name of the actual object referred by 215106760
> in the error message?
>

SELECT relname FROM pg_class WHERE oid = 215106760;

Kris Jurka