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. This looks like you defined the function in template1 *after* you created the user's DB. Or never defined it there at all. Try defining the function in the user's DB itself or, if able, recreate the user's DB after defining it in template1. HTH. Bosco. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
