Re: Unprivileged access to pgsql functions?

On Fri, Mar 4, 2011 at 1:51 PM, Andrew Sullivan <ajs(at)crankycanuck(dot)ca> wrote:

> On Fri, Mar 04, 2011 at 01:41:34PM -0800, 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.
>
> Is the function in your search_path?
>
> A
>
>
> --
> Andrew Sullivan
> ajs(at)crankycanuck(dot)ca
>
>
Not sure. I believe public and pg_catalog are in the path by default. Most
of the create function declarations prepend pg_catalog, and I believe I saw
somewhere that pg_catalog is the default. But I may be misunderstanding
that...