On Fri, Mar 4, 2011 at 1:48 PM, Bosco Rama
<postgres@boscorama.com> wrote:
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.
The function cannot be defined in the user's DB because "language C" is considered a security risk, so only the superuser can do that. Or that's what I get from reading anyway...
Recreating the user DB is problematic because there are already tables in place.
Matt