Skip site navigation (1) Skip section navigation (2)

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

From: "Karl Walbrecht" <kwalbrecht(at)cghtech(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5460: Search path not being used in function return type
Date: 2010-05-13 11:55:16
Message-ID: 201005131155.o4DBtGui033586@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5460
Logged by:          Karl Walbrecht
Email address:      kwalbrecht(at)cghtech(dot)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

Responses

pgsql-bugs by date

Next:From: Erwin BrandstetterDate: 2010-05-13 13:19:38
Subject: Re: BUG #5460: Search path not being used in function return type
Previous:From: Peter EisentrautDate: 2010-05-13 11:50:33
Subject: Re: BUG #5447: VPATH install postgres.bki

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group