PL/pgSQL and JDBC, Relation 'Number' does not exist

From: Daniel(dot)Stoinski(at)nagler-company(dot)com
To: pgsql-jdbc(at)postgresql(dot)org
Subject: PL/pgSQL and JDBC, Relation 'Number' does not exist
Date: 2002-08-08 07:20:52
Message-ID: 1028791252.3d521bd44bf7b@www.nagler-company.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
I wrote a pl/pgSQL routine, which I call from an SQL query through JDBC. If I
start this SQL query from psql, it works fine. From the Servlet I get from time
to time an SQLException with, for example, 'Relation 543167 does not exist'.
I don't use any relations with this name (or number). At this time I have only
catched and ignored the exception, because the pl/pgSQL program and the whole
query seem to work.
I won't torture You with the whole code, but I will send it to You, if it could
help to answer the question.
Best regards from Munich
Daniel

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Paesold 2002-08-08 09:16:06 EXPLAIN via jdbc
Previous Message Barry Lind 2002-08-07 19:47:38 Re: BUG FIX