Galantucci Giovanni wrote:
> Hi all,
>
> I'm using jdbc to connect to a remote database and this morning I've
> found an SQLException on my log file with this error description:
>
> "could not open relation with OID ...".
>
> Does anyone know which error code is associated to such exception?
It's usually down to a cached plan referring to a temporary table that's
being replaced. Could be a normal table being dropped/recreated though.
It could be a query-plan cached by your jdbc stuff or perhaps a plpgsql
function using TEMP tables?
--
Richard Huxton
Archonet Ltd