BUG #2185: function compilation error with "Create [TEMP] table?

From: "marc mamin" <m(dot)mamin(at)gmx(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2185: function compilation error with "Create [TEMP] table?
Date: 2006-01-19 12:57:56
Message-ID: 20060119125756.33987F0B01@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2185
Logged by: marc mamin
Email address: m(dot)mamin(at)gmx(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Chris Campbell 2006-01-19 13:25:11 Re: Huge number of disk writes after migration to 8.1
Previous Message Magnus Hagander 2006-01-19 11:51:44 Re: Huge number of disk writes after migration to 8.1