The following bug has been logged online:
Bug reference: 5460
Logged by: Karl Walbrecht
Email address: kwalbre...@cghtech.com
PostgreSQL version: 8.4.3
Operating system: Solaris x86 64 bit
Description: Search path not being used in function return type
Details:
# show search_path;
search_path
------------------
security, public
-- This works
CREATE OR REPLACE FUNCTION sec_authorization_check_all(
v_entity_name varchar
) RETURNS setof security.entities AS
-- This does not
CREATE OR REPLACE FUNCTION sec_authorization_check_all(
v_entity_name varchar
) RETURNS setof entities AS
psql:./functions/sec_authorization_check_all.sql:41: ERROR: type "entities"
does not exist
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
