On Fri, Mar 4, 2011 at 1:51 PM, Andrew Sullivan <a...@crankycanuck.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 > a...@crankycanuck.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...
