Re: Unprivileged access to pgsql functions?

On Fri, Mar 4, 2011 at 1:49 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 03/04/11 1:41 PM, Matt Warner wrote:
>
>> No luck:
>>
>> *** as postgres
>> postgres=# GRANT all on function nvl(anyelement,anyelement) to public;
>> GRANT
>> postgres=#
>>
>> *** as unprivileged user
>> offload=> select nvl(0,1);
>> ERROR: function nvl(integer, integer) does not exist
>> LINE 1: select nvl(0,1);
>> ^
>> HINT: No function matches the given name and argument types. You might
>> need to add explicit type casts.
>>
>>
> what schema is this function defined in? is that schema in the search
> path?
>
>
> l <http://www.postgresql.org/mailpref/pgsql-general>

The function was loaded as user postgres since it's a C-language module. The
definitions for most of the functions in the script have pg_catalog as the
prefix (e.g. CREATE FUNCTION pg_catalog.to_date(str text)).