BUG #2185: function compilation error with "Create [TEMP] table?
От | marc mamin |
---|---|
Тема | BUG #2185: function compilation error with "Create [TEMP] table? |
Дата | |
Msg-id | 20060119125756.33987F0B01@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #2185: function compilation error with "Create [TEMP] table?
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 2185 Logged by: marc mamin Email address: m.mamin@gmx.net PostgreSQL version: 8.1 Operating system: DB Server: Linux Client: windows XP Description: function compilation error with "Create [TEMP] table? Details: within a function, when I: - use create temp table , - do anyting with this table - drop that table, The first call to that function works, but further calls fail. Rebuilding the function before each call fix the issue. I guess that the function is not yet compiled at the first call, and that further calls use a compiled version.... Cheers, Marc Here the steps to repeat the bug: --------------------------------- CREATE OR REPLACE FUNCTION bugtest() RETURNS int AS $BODY$ BEGIN create temp table bugt(i int); insert into bugt values(1); drop table bugt; RETURN 0; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE; select bugtest(); -->0 select bugtest(); -->ERROR: relation with OID 52284 does not exist -->CONTEXT: SQL statement "insert into bugt values(1)" -->PL/pgSQL function "bugtest" line 9 at SQL statement
В списке pgsql-bugs по дате отправления: