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
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 |