basic temp table question

["L. Fletcher" <lucasf@xxxxxxxxxxxxxxxxxxxxx>]

 

Hello,

 

The first time I run a query against this function (using Npgsql):

 

declare
       r_cursor1 cursor for

 

       SELECT * from tmp_table;

 

begin

 

       CREATE TEMPORARY TABLE tmp_table
        (
              testcol integer
        ) ON COMMIT DROP;

 

       INSERT INTO tmp_table
       SELECT 0;

 

       open r_cursor1;
 
       return 0;
end;

 

I get this error:

 

ERROR: XX000: relation 1090457025 is still open

 

All subsequent times I get this error:

 

ERROR: 42P01: relation with OID 1090457025 does not exist

 

What am I doing wrong?

 

(Sorry if this is a basic question.)

 

Thanks in advance...