[BUGS] BUG #1692: Drop table in plpgsql

[Jocelyn Turcotte]

The following bug has been logged online:

Bug reference:      1692
Logged by:          Jocelyn Turcotte
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system:   Debian linux 1:3.3.5-12
Description:        Drop table in plpgsql
Details: 

I dont know if this bug is known (it seems to be a bug though), did not find
the todo list on the site.
If I execute the folowing code I get the error:

ERROR:  relation with OID 3374698 does not exist
CONTEXT:  SQL statement "INSERT INTO tmp values (1)"
PL/pgSQL function "bugtest" line 8 at SQL statement

Code:

CREATE OR REPLACE FUNCTION bugtest() returns integer as $proc$
    DECLARE
        yo record;
    BEGIN
        CREATE TEMP TABLE tmp (
            col INTEGER 
        ) ON COMMIT DROP;

        INSERT INTO tmp values (1);
        
        select into yo col from tmp;
        
        DROP TABLE tmp;
        RETURN 0;
    END;
$proc$ language plpgsql;

select bugtest();
select bugtest();

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly