John Duffy (jbduffy@ntlworld.com) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
plpgsql function fails on second call
Long Description
A function containing a left outer join declared to return a set works correctly when first called. A second call to
thefunction terminates with an error. If the function is recreated the function then works correctly for the first call
andthen fails on the second.
Sample Code
createdb test
create table a (id integer, value integer)
create table b (id integer, value integer)
insert into a (id, value) values (1,1)
insert into a (id, value) values (2,2)
insert into a (id, value) values (3,3)
insert into b (id, value) values (1,1)
insert into b (id, value) values (2,2)
insert into b (id, value) values (3,3)
create type ab as (a integer, b integer)
createlang plpgsql test
create or replace function test() returns setof ab as '
declare
row ab%ROWTYPE;
begin
create temp table ab as
select a.value as a_value, b.value as b_value
from a left outer join b
on a.id = b.id;
for row in select * from ab loop
return next row;
end loop;
drop table ab;
return;
end;
' language 'plpgsql';
test=# \i test-func.sql
CREATE FUNCTION
test=# select * from test();
a | b
---+---
1 | 1
2 | 2
3 | 3
(3 rows)
test=# select * from test();
WARNING: Error occurred while executing PL/pgSQL function test
WARNING: line 9 at for over select rows
ERROR: pg_class_aclcheck: relation 3759490 not found
No file was uploaded with this report