Good afternoon.
I've been looking at the Oracle Functionality package. It's very
interesting. However, the one place I'm stuck is that while user Postgres
can access the functions, no other user seems to have access. I'm sure this
is something simple I'm missing, but so far Google hasn't shown me the
answer.
I've already tried explicitly granting execute permissions on the function,
and the search path, as I understand it, is already supposed to be looking
in pg_catalog.
Any pointers?
**** Non-privileged user*
offload=> select nvl(null,1);
ERROR: function nvl(unknown, integer) does not exist
LINE 1: select nvl(null,1);
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
offload=> \q
-bash-3.00$
**** Postgres user*
-bash-3.00$ psql
psql (9.0.3)
Type "help" for help.
postgres=# select nvl(null,1);
nvl
-----
1
(1 row)
postgres=# \q
TIA,
Matt
