[GENERAL] basic temp table question

  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_tabl

Re: [GENERAL] basic temp table question

"L. Fletcher" <[EMAIL PROTECTED]> writes: > I get this error: > ERROR: XX000: relation 1090457025 is still open This is an 8.0 bug fixed in 8.0.1. > All subsequent times I get this error: > ERROR: 42P01: relation with OID 1090457025 does not exist=20 This is because plpgsql caches plans and ther

[GENERAL] basic temp table question

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