view/pgpgsql functions bug

[Joe Maldonado <jmaldonado@xxxxxxxxxxxxxxx>]

After a create or replace view, the new view definition is not being
used by plpgsql functions that use the view. Is this a known bug ? Is
there a workaround it ?

For instance, selecting from afunc() still returns the old view's results.

create table c ( a int );
create or replace view a as select * from c;
insert into c values (1);

create or replace function afunc() returns integer AS'
declare
   val int;
begin
   select into val a from A;
   return val;
end;
' language 'plpgsql';

select * from afunc(); 
afunc
-------
    1
(1 row)

create table d ( a int );
create or replace view a as select * from d;
insert into d values (2);

select * from afunc();
afunc
-------
    1
(1 row)

Thanks.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match