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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
