basic temp table question

L. Fletcher · *nix forums beginner Joined: 01 Mar 2005 Posts: 3

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...

Google