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?  (Jaime Casanova <systemguards@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Gilles"
Дата:
Сообщение: BUG #2180: log_statement=mod does not work
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #2182: Internal account lookup failure: