Skip site navigation (1) Skip section navigation (2)

PL/pgSQL bug?

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: PL/pgSQL bug?
Date: 2001-09-30 12:13:02
Message-ID: 20010930211302X.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
In the attached script, second call to test1() causes error:

select test1();
 test1 
-------
     0
(1 row)

select test1();
psql:/home/t-ishii/tmp/aaa.sql:13: NOTICE:  Error occurred while executing PL/pgSQL function test1
psql:/home/t-ishii/tmp/aaa.sql:13: NOTICE:  line 5 at select into variables
psql:/home/t-ishii/tmp/aaa.sql:13: ERROR:  Relation 422543 does not exist

Maybe PL/pgSQL cache problem?
--
Tatsuo Ishii
----------------------------------------------------------------------
drop function test1();
create function test1() returns int as '
declare
rec RECORD;
begin
create temp table temp_aaa (i int);
select into rec * from temp_aaa;
drop table temp_aaa;
return 0;
end;
'language 'plpgsql';
select test1();
select test1();

Responses

pgsql-hackers by date

Next:From: Doug McNaughtDate: 2001-09-30 15:11:43
Subject: Re: Pre-forking backend
Previous:From: Gavin SherryDate: 2001-09-30 10:12:20
Subject: Re: Pre-forking backend

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group