[BUGS] pl/pgsql problem with search_path

[Eugene Chow]

My plpgsql function seems to be ignoring search_path when looking for 
the right table to select from. I'm running 7.3.4. Below is my test 
code. Am I doing something wrong?

TIA, Gene Chow

test=> create or replace function getval() returns varchar as '
test'> declare val varchar;
test'> begin
test'>     select into val value from bar limit 1;
test'>     return val;
test'> end;' language 'plpgsql';
CREATE FUNCTION
test=> create table public.bar ( value varchar );
CREATE TABLE
test=> insert into public.bar values ('public value');
INSERT 4012748 1
test=> create schema foo;
CREATE SCHEMA
test=> create table foo.bar ( value varchar );
CREATE TABLE
test=> insert into foo.bar values ('foo value');
INSERT 4012754 1
test=> set search_path to foo, public;
SET
test=> select *, getval() from bar;
   value   |  getval
-----------+-----------
 foo value | foo value
(1 row)
test=> set search_path to public;
SET
test=> select *, getval() from bar;
    value     |  getval
--------------+-----------
 public value | foo value
(1 row)
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings