From: | Alex <alex(at)meerkatsoft(dot)com> |
---|---|
To: | Kris Jurka <books(at)ejurka(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: SQL Exception Relation xxx does not exist |
Date: | 2004-01-21 05:25:23 |
Message-ID: | 400E0D43.30204@meerkatsoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers |
Kris,
thanks for the reply. I dont actually use temp tables in the function
(not that I know of) but I did truncated and reloaded a few tables incl.
recreating indices the previous day, however the line no. indicated in
the serverlog does not point to these sql calls.
I am now re-starting tomcat every night which is not a bad thing anyway
but still am wondering what the real reason could be.
Alex
Kris Jurka wrote:
>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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2004-01-21 11:33:32 | Re: SQL Exception Relation xxx does not exist |
Previous Message | Greg Sabino Mullane | 2004-01-21 01:52:37 | Re: Organizing the OSCON presence |
From | Date | Subject | |
---|---|---|---|
Next Message | Chris | 2004-01-21 08:37:56 | Re: SCO Extortion |
Previous Message | Marc G. Fournier | 2004-01-21 04:53:25 | Re: SCO Extortion |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-01-21 08:08:07 | SET WITHOUT OIDS and VACUUM badness? |
Previous Message | Tatsuo Ishii | 2004-01-21 04:51:52 | Re: Encoding problems in PostgreSQL with XML data |