Re: BUG #4051: ERROR: relation with OID xxxx does not exist

On Mon, Mar 24, 2008 at 5:50 PM, N Jagan Mohan Rao
<n(dot)jaganmohanrao(at)rediffmail(dot)com> wrote:

>
> I am using EntityManager, NativeQueries and deleting postgresql tables and
> createing them dinamically(the schema is generated by using hybernate-tool).
> till this point it is working fine .. and in the same transaction i am
> putting some data and saving it through entitymanager and hence I am getting
> the problem "ERROR: relation with OID xxxxxx does not exist" please give the
> solution for this. I tried but I am unable to fix it.
>

I don't know much about EntityManager etc, but I have seen this issue with
plpgsql functions on version older than 8.3 (starting 8.3, we have plan
invalidation which addresses this problem)

For example, a simple way to reproduce this on pre-8.3 versions is:

postgres=# CREATE TABLE test (a int);
CREATE TABLE

postgres=# CREATE OR REPLACE FUNCTION testfunc(integer) RETURNS VOID AS
$$
BEGIN
INSERT INTO test VALUES (1);
END;
$$
language plpgsql;
CREATE FUNCTION

postgres=# SELECT testfunc(0);
testfunc
----------

(1 row)

postgres=# DROP TABLE test;
DROP TABLE

postgres=# SELECT testfunc(0);
ERROR: relation with OID 16390 does not exist
CONTEXT: SQL statement "INSERT INTO test VALUES (1)"
PL/pgSQL function "testfunc" line 2 at SQL statement

If upgrading to 8.3.1 is an option, you can try that.

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com