BUG #1692: Drop table in plpgsql
От | Jocelyn Turcotte |
---|---|
Тема | BUG #1692: Drop table in plpgsql |
Дата | |
Msg-id | 20050531185850.C9618F0AC7@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #1692: Drop table in plpgsql
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1692 Logged by: Jocelyn Turcotte Email address: turcotte.j@gmail.com 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();
В списке pgsql-bugs по дате отправления: