Re: BUG #5460: Search path not being used in function return type

"Karl Walbrecht" <kwalbrecht(at)cghtech(dot)com> writes:
> Description: Search path not being used in function return type

Works as expected for me ...

$ psql
psql (8.4.3)
Type "help" for help.

regression=# create schema security;
CREATE SCHEMA
regression=# create type security.entities as enum ('a','b');
CREATE TYPE
regression=# set search_path = security, public;
SET
regression=# CREATE OR REPLACE FUNCTION sec_authorization_check_all(
v_entity_name varchar
) RETURNS setof security.entities AS $$
select 'a'::security.entities$$ language sql;
CREATE FUNCTION
regression=# CREATE OR REPLACE FUNCTION sec_authorization_check_all(
v_entity_name varchar
) RETURNS setof entities AS $$
select 'a'::security.entities$$ language sql;
CREATE FUNCTION
regression=#

regards, tom lane