| From: | "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #1064: work with temporary table in plpgsql function |
| Date: | 2004-01-24 08:12:35 |
| Message-ID: | 20040124081235.B9D5DCF50B0@www.postgresql.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1064
Logged by: Sergey
Email address: serg(dot)z(at)list(dot)ru
PostgreSQL version: 7.4
Operating system: FreeBSD
Description: work with temporary table in plpgsql function
Details:
If a followed function is called more once inside one session, then occured
this error:
ERROR: relation with OID 19990 does not exist
CONTEXT: PL/pgSQL function "test_temp" line 3 at SQL statement
TEST FUNCTION:
CREATE OR REPLACE FUNCTION public.test_temp()
RETURNS int4 AS
'begin
create temporary table itable(id int4, name varchar(100));
insert into itable values(1, \'test\');
drop table itable;
return 0;
end;
'
LANGUAGE 'plpgsql' VOLATILE;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Creager | 2004-01-24 21:25:39 | Re: BUG #1061: message type 0x49 arrived from server while |
| Previous Message | John Wright | 2004-01-23 21:59:17 | BUG #1052: Problem while Installation of postgreSQL |