Re: BUG #5460: Search path not being used in function return type - Mailing list pgsql-bugs

"Karl Walbrecht" <kwalbrecht@cghtech.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